SCCM report

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

You can find out which machines have project installed with the built-in reports assuming you have Hardware Inventory (that'll get you Add/Remove Programs data) or Software Inventory (that'll get you .EXE's on the disks) enabled. Have you installed a Reporting Point?
 
Can you elaborate on the subnet requirements?

Try this.
http://tinyurl.com/7zb8ufd

Thanks for the reply . We have two floors and they are on different subnet and we want to check Project 2007 installed on the PC's on those floors. Could you please eloborate how to run queries as well
 
Regards
Jigs

This should get you started. http://technet.microsoft.com/en-ca/library/bb694212.aspx

Jigs
Is this what you are looking for?
 
select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.NetbiosName from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Project%" and SMS_R_System.IPSubnets like "%10.1%"

Thanks all
 
I created a report with the code below and it worked like a charm
 
Select sys.Netbios_Name0, fcm.SiteCode,  sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0
FROM v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE DisplayName0 = 'Microsoft Office Project Professional 2007' and
 
 
Thanks for your support and inputs
 
 

FYI, your query got cut off. Look at your Where clause notice the And in hte last line.