Tag : sql report

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]