| /* | |
| This query will show you the count of records per Hardware Inventory class in your HinvChangeLog table for a period between | |
| 21 days ago, and 28 days ago | |
| */ | |
| SELECT map.DisplayName | |
| , map.InvClassName AS 'Inventory View' | |
| , COUNT(HINV.RecordID) | |
| FROM HinvChangeLog hinv | |
| LEFT JOIN v_GroupMap map ON map.GroupID = hinv.GroupKey | |
| WHERE hinv.TimeKey > DATEADD(day, -28, GETDATE()) AND hinv.TimeKey < DATEADD(day, -21, GETDATE()) | |
| GROUP BY map.DisplayName | |
| , map.InvClassName | |
| ORDER BY 3 DESC | |
| /* | |
| This query will show you the count of records per Hardware Inventory class in your HinvChangeLog table for the last week | |
| */ | |
| SELECT map.DisplayName | |
| , map.InvClassName AS 'Inventory View' | |
| , COUNT(HINV.RecordID) | |
| FROM HinvChangeLog hinv | |
| LEFT JOIN v_GroupMap map ON map.GroupID = hinv.GroupKey | |
| WHERE hinv.TimeKey > DATEADD(day, -7, GETDATE()) | |
| GROUP BY map.DisplayName | |
| , map.InvClassName | |
| ORDER BY 3 DESC |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment