SCCM 2012 Software Metering Report

I fully admit that I am a complete SQL noob. I'm not even a Noob, below noob even.

But here's my question, working in SCCM Reporting, specifically regarding Software Metering.

I've taken the out-of-the-box report "Computers that have a metered program installed byt have not run the program since a specified date".

All I want to do it add the last logged on user to the report results. It's probably simple, I just cannot figure this reporting thing out at all.

Thanks in advance for any assitance!!

August 26th, 2015 2:22pm

Hi,

Please check the query as reference.

Select
    R.Netbios_Name0,
    R.User_Domain0 + '\' + R.User_Name0,
    CS.UserName0
from
    dbo.v_R_System R
    join dbo.v_GS_COMPUTER_SYSTEM CS on R.ResourceID = CS.ResourceID
    join dbo.v_FullCollectionMembership FCM on R.ResourceID = FCM.ResourceID
Where
    FCM.CollectionID = 'SMS00001'

Last Logon User

Note: Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

Free Windows Admin Tool Kit Click here and download it now
September 1st, 2015 1:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics