SWQL issues with modern dashboards

Thanks for the feedback on the Modern Dashboards.  Did you already check out the content (with customizations) that we've put into the Content Exchange? If you can, would you be able to share the query so we can examine it more closely.  Most (yes, not all) of the customizations should be happening automatically and I'd like to see what you're seeing.

I mostly use Modern Dashboards as summary pages and they are useful for wallboard displays. I agree there are various things with them that would make life a bit easier. 

I have also run into the same DateTime format issue.

As an example for KMSigma.SWI, any query with a DateTime field:

e.g SELECT TOP 10 NodeID, DateTime from Orion.ResponseTime

• Raw output - no formatting

• Format = Datetime. Datetime Format = Full

• Format = Datetime. Datetime Format = Compact.  This errors out and you can't save the change.

So your only option is the super long date format, or the default format, or format the datetime in the SWQL query itself.

You should see the same issue if you try to use the functions listed, are you looking for me to make a video of it throwing the error? Find me a way to group like the tree view in classic. Find me a way to put commas into big numbers. If you're confined to only use the modern dashboard you're confined to using SWQL and I've listed several gaps in it which should be easily testable/verifiable. That said here is a query that has the examples I referenced... I think.

I pasted a screenshot of the error when trying to use compact format for date/time but Shuth below has a more detailed post on it below so I won't go into that one. 

SELECT TOP 10
IT.NodeID
, N.Caption
, N.DetailsUrl
, INT.Name
, IT.InterfaceID
-- Date Time insanity
, datetrunc('minute',IT.datetime) as Date
, Round(IT.InAveragebps / 8 / 1000000, 1) AS InAvgMBps
, IT.InMinbps
, IT.InMaxbps
, IT.InTotalBytes
, IT.InTotalPkts
, Round(IT.OutAveragebps/ 8 / 1000000, 1) AS OutAvgMBps
, IT.OutMinbps
, IT.OutMaxbps
, IT.OutTotalBytes
-- Number formating woes
, IT.OutTotalPkts
, IT.TotalBytes
, IT.TotalPackets
, Round(IT.Averagebps/ 8 / 1000000, 1) AS AvgMBps
, IT.Description
, Round(IT.OutPercentUtil, 1) AS OutPerUtil
, Round(IT.InPercentUtil, 1) AS InPerUtil
, Round(IT.PercentUtil, 1) AS PerUtil


FROM Orion.NPM.InterfaceTraffic as IT
INNER JOIN Orion.Nodes N ON N.NodeID = IT.NodeID
INNER JOIN Orion.NPM.Interfaces INT ON INT.InterfaceID = IT.InterfaceID

WHERE IT.DateTime >= AddDay(-7, GETUTCDATE())
AND IT.PercentUtil > 10.0

ORDER BY IT.PercentUtil DESC

This feels like a bug for Modern Dashboards.  Has anyone opened a ticket?  If so, DM me the number and I'm happy to look into it.

I can confirm that the formatting of compact is OK as a JSON option

[Option value of 0 = Compact, Option value of 1 = Full]

This is most definitely a bug (IMHO) and someone should raise a ticket.

How did I test this?

1. I created the table widget using this query:
   

   SELECT TOP 10 [Nodes].Caption
        , [Nodes].DetailsUrl AS [CaptionUrl]
        , [Nodes].Interfaces.Caption AS [InterfaceCaption]
        , [Nodes].Interfaces.DetailsUrl AS [InterfaceUrl]
        , [Nodes].Interfaces.Traffic.Averagebps AS [AvgBps]
        , [Nodes].Interfaces.Traffic.InAveragebps AS [InAvgBps]
        , [Nodes].Interfaces.Traffic.InMinbps
        , [Nodes].Interfaces.Traffic.InMaxbps
        , [Nodes].Interfaces.Traffic.InTotalBytes
        , [Nodes].Interfaces.Traffic.InTotalPkts
        , [Nodes].Interfaces.Traffic.OutAveragebps AS [OutAvgBps]
        , [Nodes].Interfaces.Traffic.OutMinbps
        , [Nodes].Interfaces.Traffic.OutMaxbps
        , [Nodes].Interfaces.Traffic.OutTotalBytes
        , [Nodes].Interfaces.Traffic.OutTotalPkts
        , [Nodes].Interfaces.Traffic.ObservationTimestamp
   FROM Orion.Nodes AS [Nodes]
   WHERE [Nodes].Interfaces.Traffic.ObservationTimestamp >= AddDay(-7, GETUTCDATE())
     AND [Nodes].Interfaces.Traffic.PercentUtil > 10.0
   ORDER BY [Nodes].Interfaces.Traffic.PercentUtil DESC

2. I selected the date field's formatting as DateTime and selected full.
3. I saved the Modern Dashboard.
4. I exported the Modern Dashboard.
5. I edited the resulting JSON and flipped the 1 to 0 in the formatter properties for that field.
   
6. I saved the JSON file.
7. I imported it back to my Orion Platform with the -Force parameter to allow overwrite.

This is my result:

This is also why I think this is a bug with the UI of the Modern Dashboard builder: definitions that exist and are formatted correctly will render, but you just can't select the Compact option from the drop down and get it to save. 

It's one bug of many, and given the modern dashboards have been out over 2 years at this point it's pretty sad it's this buggy.

Thanks for the workaround KMSigma.SWI. I'll happily put a ticket in for SolarWinds on this if nobody has yet. I just noticed this last week when building a team dashboard template based off jm_sysadmin's template.

That would be lovely.  Then DM me the case # so I have a record.  I think the team is already working on it, but having customers state that they are seeing this in the wild is preferred.  After all, if no one opens a ticket, the team doesn't know that the thing isn't working.  

Case submitted  sent you the case #. Also was able to use your workaround in my template, nice!

Appreciate it sum_giais - once we have the issue tracked internally, then it can be bubbled up to the devs to see if a HF can be issued to resolve the issue.