last scanned date for SG-SCCM for Software - is it last time SCCM scanned software or computer ?

[Somnath Shilimk]

Hi Everyone,

What does "last scanned" attribute stands for SG-SCCM Software Data Source ?

It is not documented anywhere in ServiceNow documentation. 

My understanding is : It is timestamp when SCCM scanned that software successfully

Below is database query from the SG-SCCM Software. query says LastHWScan but from statement the query points to is from "v_GS_INSTALLED_SOFTWARE ", therefore I am confused here is that it is time stamp of Workstation successfully scanned by SCCM or time stamp of software scanned successfully by SCCM ?

" SELECT t.groupID, t.DisplayName, t.Version, t.InstallDate, t.InstallSource, t.ProdID, t.Publisher, t.arTimeStamp, t.revisionID, t.resourceID, t.name0, t.ComputerTimeKey, t.LastHWScan, v_FullCollectionMembership.CollectionID

, '8cf0453a33140e5468269aa13d5c7b65' as connectionid
FROM (SELECT v_GS_INSTALLED_SOFTWARE.GroupID AS groupID, v_GS_INSTALLED_SOFTWARE.ProductName0 AS DisplayName, v_GS_INSTALLED_SOFTWARE.ProductVersion0 AS Version, v_GS_INSTALLED_SOFTWARE.InstallDate0 AS InstallDate,

v_GS_INSTALLED_SOFTWARE.ProductID0 AS ProdID, v_GS_INSTALLED_SOFTWARE.InstallSource0 AS InstallSource, v_GS_INSTALLED_SOFTWARE.Publisher0 AS Publisher, CONVERT(datetime, SWITCHOFFSET(TODATETIMEOFFSET(v_GS_INSTALLED_SOFTWARE.TimeStamp, DATEPART(tz, SYSDATETIMEOFFSET())), 0))

AS arTimeStamp, v_GS_INSTALLED_SOFTWARE.RevisionID AS revisionID, v_GS_INSTALLED_SOFTWARE.ResourceID AS resourceID, v_GS_COMPUTER_SYSTEM.Name0 AS name0, WorkstationStatus_DATA.TimeKey AS ComputerTimeKey,

WorkstationStatus_DATA.LastHWScan

FROM v_GS_INSTALLED_SOFTWARE LEFT OUTER JOIN

WorkstationStatus_DATA ON WorkstationStatus_DATA.MachineID = v_GS_INSTALLED_SOFTWARE.ResourceID INNER JOIN

v_GS_COMPUTER_SYSTEM ON v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_INSTALLED_SOFTWARE.ResourceID

WHERE (v_GS_INSTALLED_SOFTWARE.ProductName0 <> '')) AS t INNER JOIN

v_FullCollectionMembership ON t.resourceID = v_FullCollectionMembership.ResourceID "

[AJ-TechTrek]

Hi @Somnath Shilimk ,

Last scan date is from SCCM, Means when the last time SCCM runs and updated the data in SCCM for Computer , Software etc.

That is pulled by SCCM Graph connector to update in CMDB to showcase the its updated that particular time and this is time gap between SCCM and ServiceNow Sync.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

[KeithM178992478]

Thanks AJ.

What about the "Updated" field? Any idea what that represents?