mike

Thanks that would great if you could do so. I will try to create the script from your advice and see if I can make it work. Appreciate your help, Mike

Hi, This site is great! Keep up the great work. I am trying to generate a report that will scan the comptuers in the CM and report back if they have a certain software (i.e. Adobe, Symantec, etc). Then, eventually the version and so on. (I am trying to start off small then eventuall grow on the reports). So I created the report below, but it returns an error when ever the % signs are in place. The error that follows when trying to run is : An error occurred when the report was run. The details are as follows: Conversion failed when converting the varchar value 'Adobe PDF Broker Process for Internet Explorer' to data type int. Error Number: -2147217913 Source: Microsoft OLE DB Provider for SQL Server Native Error: 245 I tried some trouble shooting like removing the % signs and then changing the like name but either the reports fail with another error or they report back nothing(report runs but no data). SELECT Netbios_Name0, User_Name0,Operating_System_Name_and0 FROM v_R_System RIGHT JOIN v_SoftwareProduct ON v_R_System.ResourceID =v_SoftwareProduct.ProductName WHERE ProductName like '%Adobe%' (So in this report, I think I am saying that I want a list of all the systems in the CM with Adobe. Is this correct.) I would appericate if someone could let me know what is wrong in my script or point me in the right direction. Thanks, Mike

No, I dont have that option enabled. But I will take a look and test it out. Thank you, Mike

I am running SCCM SP1 on Win2k8. Is there a way to detect network printers on a network using CM? If so, how do I do so? Thanks, Mike