Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(ID) as InstallCount, SU.Usage,
- CASE WHEN SU.AppName LIKE 'Microsoft Visio Standard%' THEN 'Visio Standard'
- WHEN SU.AppName LIKE 'Microsoft Visio Professional%' THEN 'Visio Professional'
- WHEN SU.AppName LIKE 'Microsoft Visio Premium%' THEN 'Visio Premium'
- WHEN SU.AppName LIKE 'Microsoft Visio for Enterprise Architects%' THEN 'Visio Enterprise Architects' ELSE 'Visio Standard' END as EditionName, ISNULL(PL.Price, 0) as Price, ISNULL(SUM(total_times_used),0) as TimesUsed,
- ISNULL(SUM(total_min_used),0) as MinutesUsed, SU.StatusDate,
- DATENAME(WEEKDAY, SU.StatusDate) as DayofWeek,
- DATENAME(Month, SU.StatusDate) as MonthofYear,
- DATENAME(Day, SU.StatusDate) as NumberofWeek,
- DATENAME(Year, SU.StatusDate) as Year,
- DATENAME(DAYOFYEAR, SU.StatusDate) as YearDay
- FROM [PATCHDW].[dbo].[SoftwareUsageVisio] AS SU with (nolock) INNER JOIN
- [PATCHDW].[dbo].[SoftwareTitlePriceList] AS PL with (nolock) ON SU.AppName = PL.AppName
- Group by SU.Usage, SU.AppName, StatusDate, PL.Price
- Order by SU.Usage, SU.AppName DESC, YearDay DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement