I only need to import couple laptops' installations and users from SCCM database. But I got all laptops although the reader file was modified.
This is what I did:
1. Added the computer names that I want to import in the where clause below (line 626) in computer.xml reader file.
2. Replace the computer.xml file in ...ImportProcedures\Inventory\Reader\SMS
3. Restart the beacon engine and create the connection.
Is there anything I missed or did wrong?
LEFT OUTER JOIN v_GS_COMPUTER_SYSTEM AS vgcs ON vgcs.ResourceID = c.MachineID
LEFT OUTER JOIN v_R_System AS vrs ON vrs.ResourceID = c.MachineID
Where c.name0 IN (’NUSZ28829408‘,’NUSZ28829386‘,’NUSZ28822094‘,’NUSZ28829363‘,’NUSZ28829388‘,’NUSZ28829389’)
ORDER BY MachineID, InventoryDate DESC
Thanks a lot!
Jan 07, 2020 12:18 PM
Depending on what was done before, you might have to force an update of the data here and there. Reason is that the Reader and Writer normally only collect deltas from what was imported the last time.
Which reader step did you change? You should be looking for "Build relevant computer list", because this one defines what is going to be imported in the rest of the reader.
Jan 07, 2020 03:08 PM - edited Jan 07, 2020 03:09 PM
A few thoughts:
Jan 07, 2020 07:27 PM