SCCM SQL Report for All Office Users
Here is the sccm sql report statement to finding out all office users, I have used “Microsoft Office Professional” as the keyword, you can change to any software title you want :)
SELECT DISTINCT TOP (100) PERCENT RV.AD_Site_Name0 AS [AD Site], RV.Netbios_Name0 AS [PC Name], RV.Creation_Date0 AS [PC Joined Date], RV.User_Name0 AS [User Name], dbo.v_GS_INSTALLED_SOFTWARE.ProductName0, dbo.v_GS_INSTALLED_SOFTWARE.ProductVersion0, dbo.v_R_User.description0 AS [Employee Location], dbo.v_R_User.Mail0 AS Email, dbo.v_R_User.title0 AS Title, dbo.v_R_User.department0 AS Department, dbo.v_R_User.manager0 AS Manger FROM dbo.v_R_System_Valid AS RV INNER JOIN dbo.v_R_User ON RV.User_Name0 = dbo.v_R_User.User_Name0 INNER JOIN dbo.v_GS_INSTALLED_SOFTWARE ON RV.ResourceID = dbo.v_GS_INSTALLED_SOFTWARE.ResourceID GROUP BY RV.Netbios_Name0, RV.AD_Site_Name0, RV.Creation_Date0, RV.User_Name0, dbo.v_R_User.department0, dbo.v_R_User.description0, dbo.v_R_User.Mail0, dbo.v_R_User.manager0, dbo.v_R_User.title0, dbo.v_GS_INSTALLED_SOFTWARE.ProductName0, dbo.v_GS_INSTALLED_SOFTWARE.ProductVersion0 HAVING (dbo.v_GS_INSTALLED_SOFTWARE.ProductName0 LIKE N’%Microsoft Office Professional%’) ORDER BY [User Name]