SCCM import set for Last Boot Up Time

[daved999]

I have a need to produce a report detailing computer assets which have not been detected on the network for a given period of time.  

Ideally, I would like to add the SCCM v_GS_OPERATING_SYSTEM LastBootUpTime0 field to the existing field map, but it appears the OOB configuration doesn't include this web service field and I'm not sure how I go about adding it.

Can anyone direct me to any specific instruction to adding this field or suggest any alternatives to extracting the information based on the standard fields?

(I "could" run this report directly from the SCCM reporting tool, but I'd like to integrate the additional CI information that we included in the Service Now asset record).

[Joel Millwood2 · Accepted solution]

Hi dave999,

You would have to add a custom Date/Time field to the Computer Table (cmdb_ci_computer) to store the Last Boot Time data.

Once you have added this custom field you could then update the Table Transform map to include a field map from the u_lastbootuptime0 field in the SCCM Operating System Import Set table (imp_sccm2012v2_os) to your newly created custom field in the Computer Table. You may also want to update the Form and List views for the Computer Table to also show this information.

Once you have added this custom field on the target Computer Table and also added a field map for it in the Table Transform Map you could reprocess the previous import set run or wait for your next scheduled import to occur.

[Luiz Lucena]

Good stuff, Joel. 
Thanks for sharing this information.

Anyone automating a retirement of computers that doesn't boot up for a long period of time?

Thanks, 

Luiz