Need query to fetch duplicate records
Question
select R.ResourceID,
R.ResourceType,
R.Name,R.SMSUniqueIdentifier,
R.ResourceDomainORWorkgroup,R.Client from SMS_R_System as r
full join SMS_R_System as s1 on s1.ResourceId = r.ResourceId
full join SMS_R_System as s2 on s2.Name = s1.Name
where s1.Name = s2.Name and s1.ResourceId != s2.ResourceId
Above query throws error.
I am getting sms_r_system is invalid.
I need help trying with new views or default query which works for this
Answers ( 4 )
Forgot to mention. The query you gave in your question is WQL i believe. It’s not SQL Query.
Here.
Anoop Sir wrote it earlier.
https://www.anoopcnair.com/configmgr-sccm-duplicate-record-issue/
I think you are defining the same table with different names? Do you this should work? I don’t think so
1. SMS_R_System as r
2. SMS_R_System as s1
3. SMS_R_System as s2
select * from vSMS_R_System isn’t the better view to use?