We have created application : Service Graph Connector for Microsoft SCCM
Type : JDBC
Query : SELECT explorerfilename0 as filename, resourceid, lastusername0 as username, lastusedtime0 as lastusedtime, TimeStamp FROM v_GS_CCM_RECENTLY_USED_APPS where explorerfilename0 IS NULL
Please see attached screen shot.
We able to pull application related data in ServiceNow but last used parameter is missing. on SCCM server this information is available but somehow we unable to fetch it in ServiceNow
Kindly assist
