sreeni

Hi Have a look on the attached document. Hope it helps.... Sreeni 2844Duplicate GUID Detection and Removal.doc

HI I hope you can find some default reports which will give you the information about this. Which version you are using? SCCM or SMS 2003 ? I found some default reports in SMS 2003 SP3,like # Hardware 2A - Estimated Computer Age by Ranges within a Collection # Hardware 2B - Computers within an age range within a Collection Thanks, Sreeni

Its my pleasure...

Hi Put this code in Query Membership Rule, while creating the collection. select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System where SMSAssignedSites is not NULL and Client is NULL and OperatingSystemNameandVersion like "%Workstation%" If you are facing any issues with the code kindly let me know. Cheers, Sreeni

Hi Hope this will help You!!!! This gives all the information except VLAN info. I am trying to find out more about the same. Will keep you posted.. ----- SELECT distinct CS.name0 as 'Computer Name', CS.resourceid as 'Resource ID', BIOS.SerialNumber0 as 'Bios serial', SE.SerialNumber0 as 'System Enclosure serial', RAA.SMS_Assigned_Sites0 as 'Site', mac.mac_addresses0 as 'MAC Address', ip.ip_addresses0 as 'IP Address' from v_GS_COMPUTER_SYSTEM CS right join v_GS_PC_BIOS BIOS on BIOS.ResourceID = CS.ResourceID right join v_GS_SYSTEM SYS on SYS.ResourceID = CS.ResourceID right join v_RA_System_SMSAssignedSites RAA on RAA.ResourceID = CS.ResourceID right join v_GS_SYSTEM_ENCLOSURE SE on SE.ResourceID = CS.ResourceID right join v_RA_System_MACAddresses MAC on MAC.resourceid = cs.resourceid left join v_RA_System_IPAddresses ip on ip.resourceid = cs.resourceid left join v_GS_NETWORK_ADAPTER nw on nw.resourceid = cs.resourceid group by CS.Name0, cs.resourceid, BIOS.SerialNumber0, SE.SerialNumber0, RAA.SMS_Assigned_Sites0, MAC.mac_addresses0, ip.ip_addresses0 order by cs.resourceid Regards, Sreeni

HI This code will give you the NIC details: SELECT a.resourceid as [Resource ID], a.Netbios_Name0 as [system Name], a.Hardware_ID0 as [MAC Address], b.serialnumber0 as [system S/No], c.macaddress0 as [NIC Address], c.adaptertype0 as [Adapter Type], c.description0 as [Description] FROM v_r_system a, v_gs_pc_bios b, v_GS_NETWORK_ADAPTER c WHERE a.ResourceID = b.ResourceID and b.resourceid= c.resourceid Cheers, Sreeni

HI I hope , you are using SCCM. The code which i given is for querying the details in SMS 2003 DB. I am sorry for that. OK .. Please modify the code like this and try. SELECT a.Hardware_ID0 as [MAC Address], a.Netbios_Name0 as [system Name], b.serialnumber0 as [system S/No] FROM v_r_system a, v_gs_pc_bios b WHERE a.ResourceID = b.ResourceID Thanks, Sreeni..

Hi I suspect the issue with the Flag config. Kindly refer to this link http://myitforum.com/cs2/blogs/jgilbert/archive/2008/10/18/client-is-installed-flag-explained.aspx Thanks, Sreeni...

Hi I did a try to modify the code and to execute. I Just modified the code which wmmayms given....Thanks for this useful code wmmayms @jeaostro Just try this... Hope it works.... ------------------- SELECT A.Name0, B.SerialNumber0, A.Manufacturer0, A.Model0, C.Name0 AS 'Processor', D.TotalPhysicalMemory0 AS 'Memory (KBytes)', E.Size0 AS 'Disk Size (MBytes)', F.MACAddress0, F.IPAddress0, G.AD_Site_Name0 AS 'AD Site', A.UserName0 AS 'Last user logged in', H.Caption0 AS 'Operating System', H.CSDVersion0 AS 'Service Pack', G.Creation_Date0 AS 'Creationdate in SMS', I.LastHWScan FROM v_GS_COMPUTER_SYSTEM A, v_GS_PC_BIOS B, v_GS_PROCESSOR C, v_GS_X86_PC_MEMORY D, v_GS_DISK E, v_GS_NETWORK_ADAPTER_CONFIGUR F, v_R_System G, v_GS_OPERATING_SYSTEM H, v_GS_WORKSTATION_STATUS I WHERE A.ResourceID = B.ResourceID AND A.ResourceID = C.ResourceID AND A.ResourceID = D.ResourceID AND A.ResourceID = E.ResourceID AND A.ResourceID = F.ResourceID AND A.ResourceID = G.ResourceID AND A.ResourceID = H.ResourceID AND A.ResourceID = I.ResourceID and F.IPAddress0 is not NULL AND F.IPAddress0 not like '0.0.0.0' GROUP BY A.Name0, B.SerialNumber0, A.Manufacturer0, A.Model0, C.Name0, D.TotalPhysicalMemory0, E.Size0, F.IPAddress0, F.MACAddress0, G.AD_Site_Name0, A.UserName0, H.Caption0, H.CSDVersion0, G.Creation_Date0, I.LastHWScan Thanks Sreeni

Hi Hope this code will be helpful for you... SELECT a.Hardware_ID0 as [MAC Address], a.Netbios_Name0 as [system Name], b.serialnumber0 as [system S/No] FROM v_r_system a, v_gs_operating_system b WHERE a.ResourceID = b.ResourceID Sreeni...

Hi Try downloading this utility - SMS Collection Commander which is created by the gr8 man Roger Zander... http://sourceforge.net/projects/smscollctr/ It helps you to add the computers to a collection in an easier way.... Hope this helps.... Sreeni..