How do i get the netflow sources in json values inside the red box?
Below where some of my attempts in getting them.
How about this?
SELECT S.Interface.DisplayName, S.InterfaceID, S.Enabled, S.LastTime, S.CBQoSEnabled, S.CBQoSLastTime, S.AutoDetectedSamplingRate
FROM Orion.Netflow.Source S
I recommend installing SWQL Studio to experiment with queries. It has a tree with the entities and properties. You can double-click on an entity in the tree to generate a query that just selects all the properties, and then adjust from there.
To get the data in your red box, use a query like this:
SELECT S.Interface.DisplayName, S.Interface.InBps, S.Interface.OutBps, S.LastTime, S.CBQoSLastTime
hi tadnner, thanks for giving me direction. I found out that using this query below, prints what i was looking for But.
SELECT DisplayName, InterfaceID, Enabled, LastTime, cbQoSEnabled, cbQoSLastTime, AutoDetectedSamplingRate, ManualSamplingRate
FROM Orion.Netflow.Source
it doesnt print the name of the interface (similar to my screenshot above) Port3, Port5, etc.. it displays NULL
I was hoping you can give me some clarity on this. thanks.
This! Thank you so much. ive been spending days just to get this output. really appreciate your help and patience.
