Need Help Running 2 Reports

[Mr Ricky]

Hello all,

 

I have never used SQL before, just started using SCCM 2007 with 1 site and multiple Distribution Points. We are a windows XP shop with Office 2007 in the process of upgrading all Laptops & Desktops from Symantec AV to MS Forefront.

 

1) I would like to run a report that shows me all the machines running forefront and which machines are still running Symantec AV.

 

2) I would like to run a report that shows me all Computer Names, Specs (Hard Drives, Memory),Serial numbers and logon user.

 

If possible, steps by steps instructions on how to use the Query etc... will be verhy helpful.

 

Thank for your help,

[Eswar Koneti]

Hello all,

 

I have never used SQL before, just started using SCCM 2007 with 1 site and multiple Distribution Points. We are a windows XP shop with Office 2007 in the process of upgrading all Laptops & Desktops from Symantec AV to MS Forefront.

 

1) I would like to run a report that shows me all the machines running forefront and which machines are still running Symantec AV.

 

2) I would like to run a report that shows me all Computer Names, Specs (Hard Drives, Memory),Serial numbers and logon user.

 

If possible, steps by steps instructions on how to use the Query etc... will be verhy helpful.

 

Thank for your help,

 

Try this : http://eskonr.wordpress.com/2009/12/12/48/