Jaekt Posted May 26, 2015 Report post Posted May 26, 2015 Hi, I'm looking to create a Report in SCCM 2012 R2. Trying to find a way to display all successfully installed computers for a specific domain, at a set date (ex. 01.01 to 30.03). It needs to exclude all failed task sequences and only show a MAC-address once (preferrably the active one). Also if possible, it would be great to show detail like: Computername, Domainname, MAC-address, Last logged on user, last logon date, Installdate / createdate Conclusion: the idea is to create a PDF of quarterly OS deployed computers. Anyone who could help me out here? Really appreciate the help Quote Share this post Link to post Share on other sites More sharing options...
0 Eswar Koneti Posted May 26, 2015 Report post Posted May 26, 2015 Jeremy posted report long ago to get the task sequence execution status including status,Task sequence name etc.http://myitforum.com/cs2/blogs/jeremyyoung/archive/2012/04/24/Sql-Query-for-ConfigMgr-Task-Sequence-Execution-Times.aspx you can edit with your requirements. Quote Share this post Link to post Share on other sites More sharing options...
0 Jaekt Posted June 8, 2015 Report post Posted June 8, 2015 Thanks for the reply, Eswar, unfortunately I do not know enough about WQL, SQL or Report Builder to go forth with the changes needed. Quote Share this post Link to post Share on other sites More sharing options...
Hi,
I'm looking to create a Report in SCCM 2012 R2.
Trying to find a way to display all successfully installed computers for a specific domain, at a set date (ex. 01.01 to 30.03).
It needs to exclude all failed task sequences and only show a MAC-address once (preferrably the active one).
Also if possible, it would be great to show detail like:
Computername, Domainname, MAC-address, Last logged on user, last logon date, Installdate / createdate
Conclusion: the idea is to create a PDF of quarterly OS deployed computers.
Anyone who could help me out here? Really appreciate the help
Share this post
Link to post
Share on other sites