I have been trying to get the last used date for software from SCCM. At least the admin for the Windows SCCM system kept referring to it as SCCM. But it is not classic standalone SCCM, but MECM, the SCCM / MECM integration was configured a few months ago prior to this current engagement. There is no institutional knowledge of why the Integration was pursued with SCCM 2016 instead of MECM. I did not know this was MECM until I asked for the version of SCCM and got a screenshot back with MECM information. Up to this point all parties on the customer side have been saying SCCM.
NOTE: I do not think that the customer will be willing to install MECM spoke.
They are getting back software information into ServiceNow fine. The issue is for Last used information for reclamation rules.
We are not receiving any data from SCCM/MECM for SCCM 2016 Software Last Used data source/ job.
This job has the query ‘SELECT explorerfilename0 as filename, resourceid, lastusername0 as username, lastusedtime0 as lastusedtime, TimeStamp FROM v_GS_CCM_RECENTLY_USED_APPS where explorerfilename0 IS NULL’
We executed the same query in SCCM/MECM and it is not returning any data but after we removed where condition in the above query then it returned with some data.
The TimeStamp column does not exist in v_GS_CCM_RECENTLY_USED_APPS table in SCCM.
Any ideas on mods I can make to change this SQL query to get information?
