Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
SCCM report

Answered SCCM report

  • Thursday, May 03, 2012 6:14 AM
     
     
    Sign In to Vote
    0
    Hi
     
    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
     

All Replies

  • Thursday, May 03, 2012 6:55 AM
     
     
    Sign In to Vote
    0
    "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

     
  • Thursday, May 03, 2012 7:39 AM
     
     Answered
    Sign In to Vote
    0

    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.ResourceID

    Where IP_Subnets0 = '192.168.1.0' and Displayname0 like 'Microsoft Office%'
    order by ip.IP_Subnets0, sys.Name0

    I hope that helps,

    regards,
    Jörgen

    -- My System Center blog ccmexec.com -- Twitter @ccmexec

     
  • Thursday, May 03, 2012 12:05 PM
     
     
    Sign In to Vote
    0
    Try this: http://tinyurl.com/7zb8ufd

    http://www.enhansoft.com/