System Center Configuration Manager TechCenter >
System Center Configuration Manager Forums
>
Configuration Manager Asset Intelligence
>
SCCM Reports for software
SCCM Reports for software
- Hi All,
I'm new to reporting in SCCM and was looking for some help in producing a report on collection "all xp computers" showing how many pc's have visio 2003 installed.
I do need to create reports for other microsoft appliacations as well however once i can see a working report setup for visio 2003 im sure i can mod it to me needs.
Any help would be great guys.
All Replies
- Hi,
You can create a basic report using these steps - http://blog.coretech.dk/confmgr07/config-mgr-inventory-and-reporting/creating-configuration-manager-2007-reports-part-ii-creating-the-first-reports/
You can also use one of the standard reports:Report Category - Asset Intelligence Report Name Software 06A - Search for installed software
This report can be used as an example. Just make sure you change Microsoft Visio 2003 to the way it is showed in Add/remove programs.
SELECT dbo.v_R_System.Name0, dbo.v_R_System.Operating_System_Name_and0, dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0
FROM dbo.v_R_System INNER JOIN
dbo.v_GS_ADD_REMOVE_PROGRAMS ON dbo.v_R_System.ResourceID = dbo.v_GS_ADD_REMOVE_PROGRAMS.ResourceID
WHERE (dbo.v_R_System.Operating_System_Name_and0 LIKE '%5.1%') AND (dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 = 'Microsoft Visio 2003')
Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products
