chris.mcmorris · Senior Technical Architect

Many thanks for the reply and thanks for sharing. This report looks really interesting and useful - I'll take a look at putting something similar together for our campus LAN building uplinks and our numerous WAN links. Cheers

Many thanks, Adam - this works very well and thank you for the detailed explanation. Clearly I have lots to learn with SWQL but I'll keep trying / experimenting Cheers, Chris

Just to report back - this worked! Thank you, Adam! I used a variation of your query (example below) ------------ select top 1 case when length(month(getutcdate())) = 1 AND length(day(getutcdate())) = 1 then concat('"',year(GETUTCDATE()),'-0',month(GETUTCDATE()),'-0',day(GETUTCDATE()),'T00:00:00.000Z"') when…

ok thanks, Adam. I'll explore these options and come back to you. I'm thinking the only option might be to create an API user in SW locally with the same creds as the other API I'm trying to query but that just seems ridiculous(!) I think the SWQL query is the way to go to get the date format I need so I'll have a play…

Thanks Adam - can you paste in this example query and I'll give it a look / try? Cheers I think Option 2 is the best option and this is the road I had started down. I was thinking even of using some encoded SWQL that would return the current date in the format I need but..... I wasn't sure I could query SW and the other…

Thank you, Adam Yes this is what I was thinking. I kind of need SW to pull (monitor) from its own DB in order to 'track' (store) the result in SW(!) db. So I'm thinking using a custom SQL user experience monitor to query the DB and store the SUM of the specific rows. Many thanks for your suggestion. Cheers, C

Thanks Edwin for the detailed explanation - much appreciated. Unfortunately I do not think this will work for my use case. Perhaps I did not explain myself correctly so my apologies. The value I want to track is not available via the API and therefore not stored / tracked / monitored (or stored) as a metric in SW db. The…

Hi Edwin, Many thanks for your reply. Ok yes that makes sense, thank you. Can I just create a custom Perfmon setup that uses the custom SWQL query then? Sorry if that's a silly question but I am yet to play around with the Perfmon customisation - I had assumed (probably incorrectly) that you could only track 'stored'…