Dear All,

I need to prepare a SCCM reports containing

Machine name

Last logged user username is enough

Last time when machine was turned on

Serial number   

What is the time cycle when machines are cleaned from SCCM.

Could you please suggest how i can prepare the above report.

With what SQL query have you come up so far? Have you already researched the forums? Into what SQL problems are you running?