SCCM report
-
jeudi 3 mai 2012 06:14Hi
I am pretty new to SSCM 2007 and I need to generate a report based
on two subnets to find out which machines have project 2007 installed on them. I
did a bit of searching and it looks like I need to write a custom query to
genrate such report. Does anyone knows how to do this. I am still very new to
this product I am learning as I am working on it
Thanks
Jigs
Toutes les réponses
-
jeudi 3 mai 2012 06:55"Creating Custom Reports By Using Configuration Manager 2007 SQL Views" (http://www.microsoft.com/en-us/download/details.aspx?id=22052) contains useful information how to create custom reports. It also shows which views can be joined.
Torsten Meringer | http://www.mssccmfaq.de
-
jeudi 3 mai 2012 07:39
Hi,
Here is an example that should get you started, just add the second subnet and change the product to Microsoft Visio:
select ip.IP_Subnets0 [Subnet], sys.Name0 [Name], DisplayName0
from v_R_System sys
join v_RA_System_IPSubnets ip on ip.ResourceID = sys.ResourceID join v_GS_ADD_REMOVE_PROGRAMS on v_GS_ADD_REMOVE_PROGRAMS.ResourceID = sys.ResourceIDWhere IP_Subnets0 = '192.168.1.0' and Displayname0 like 'Microsoft Office%'
order by ip.IP_Subnets0, sys.Name0I hope that helps,
regards,
Jörgen-- My System Center blog ccmexec.com -- Twitter @ccmexec
- Proposé comme réponse Atul Mishra jeudi 3 mai 2012 08:21
- Marqué comme réponse Moiz Rassiwala[MSFT]Microsoft Employee, Moderator lundi 7 mai 2012 16:14
-
jeudi 3 mai 2012 12:05
.png)
