KeithDib Posted February 21, 2014 Report post Posted February 21, 2014 Hi One of the trainees has imported a number of new machines into the SCCM enviroment using 'Computer Association' as I do every day. The problem is they do not know were they imported them too. I cannot find the using a search and there are far to may collections to look in manually. Is there a query/report/script to trace these machines? I know they are in there somewhere as when I try to PXE boot the PXE reports they fail due to "no PXE advertisement assigned" can anyone help? thanks Keith Quote Share this post Link to post Share on other sites More sharing options...
Rocket Man Posted February 21, 2014 Report post Posted February 21, 2014 Hi Not saying that this will work, but this is a query I associate to a collection. What it basically does is pull in any new discovered systems or imaged out of the box systems within the last day. You could probably change the 1 at the end to suit any number of days i:e if this happened 3 days ago just insert 4 to make sure that you catch all new systems both discoverd and imaged out of the box within the past 4 days! 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 DateDiff(dd,SMS_R_System.CreationDate, GetDate()) <1 This will work whether or not the agent is installed! Quote Share this post Link to post Share on other sites More sharing options...
