hi Reece

Data validation results were very inconsistent. Removed software (in the past) were not removed from SNOW.

We sat new SQL (in SCCM 2016 Removed Software data source) today.

This historical view has entries for the past SCCM removed software.

I will be validating results tomorrow.

If you could test this query below in your system and share your results, that would be great.

thank you

Nataliya

SELECT * FROM

(SELECT
ResourceID,
GroupID + 32000000 as GroupID,
TimeStamp as DelDate,DisplayName0, AgentID
FROM v_HS_ADD_REMOVE_PROGRAMS

UNION ALL

SELECT
ResourceID,
GroupID + 64000000 as GroupID,
TimeStamp as DelDate,DisplayName0, AgentID

FROM v_HS_ADD_REMOVE_PROGRAMS_64

M)t WHERE AgentID is NULL