swellerrific · Enterprise Monitoring Sys Admin · ✭✭✭✭✭

Any status on this? Is there a work item we can monitor for this task? Thanks!

Its not just the equivalent tables and columns, but also the query functionality. I have a query that I could only do in SQL as the functions I used are not available in SWQL. One of those is the (Lag) function. So I need the ability to create a widget in the new dashboard that allows a SQL query. Otherwise, I can't get…

Same here. I answered the survey. Went back into it and looked at it and said I completed. Never got a green check. Now it says I never did it. @"danielleh" - Can you check my survey as well? Thanks bunches! 

Although the dancing in Blues was amazing, I had to go with Animal! That was a hard one! ¯\_(ツ)_/¯

If you read all the BOLD letters going down, it spells ADAPTABILITY. They had to fit in the A and I when they didn't have an associated question.

I agree this would help me a lot.

Failed - accidentally put in the 8d answer for 6d

I agree!

The DBA's. :( 

Unbelievable! Woot woot! Thank you! It was an extremely challenging mission for me but I enjoyed it and learned a couple things along the way. Keep up the great work!

I found it. I was originally using [dbo].[VolumeUsage_CS_Detail_hist]. I just found this one in "Views" and it works as expected: [dbo].[VolumeUsage_CS_Detail].

Resolved this by switching from SWQL to SQL: SELECT N.Caption AS Node ,D.[Timestamp] ,D.Caption AS Volume ,D.Prev_DiskSize_GB AS Prev_GB ,D.New_DiskSize_GB AS New_GB ,D.[VolumeType] ,D.[VolumeID] ,D.[NodeID] ,D.[VolumeTypeID] FROM (SELECT VS.[VolumeID] ,VS.[NodeID] ,VS.[Timestamp] ,ROUND(LAG(DiskSize,1,0) OVER (PARTITION…

Resolved this by switching from SWQL to SQL: SELECT N.Caption AS Node ,D.[Timestamp] ,D.Caption AS Volume ,D.Prev_DiskSize_GB AS Prev_GB ,D.New_DiskSize_GB AS New_GB ,D.[VolumeType] ,D.[VolumeID] ,D.[NodeID] ,D.[VolumeTypeID] FROM (SELECT VS.[VolumeID] ,VS.[NodeID] ,VS.[Timestamp] ,ROUND(LAG(DiskSize,1,0) OVER (PARTITION…

Hi All - I was able to resolve this by switching from SWQL to SQL and using the (LAG) function. SELECT N.Caption AS Node ,D.[Timestamp] ,D.Caption AS Volume ,D.Prev_DiskSize_GB AS Prev_GB ,D.New_DiskSize_GB AS New_GB ,D.[VolumeType] ,D.[VolumeID] ,D.[NodeID] ,D.[VolumeTypeID] FROM (SELECT VS.[VolumeID] ,VS.[NodeID]…

Thanks Bob. I am aware of that table and it is the primary table in my query. The problem is that I can't figure out how to get that DateTime added to my current query. Everything I try fails, not that I am an expert by any means.

Thanks bobmarley. It appears that these don't appear in the audit events and thats ok. I'll edit my question to remove that part. I would still like the date of change though. I can see the dates in the VolumeUsageHistory table, but haven't been able to get a query to pull it. I see Adam suggested a subquery but I'm not…

Thanks Adam. We do currently have events. I'm not sure how to do the join you are suggesting.