Your company's ad could live here and reach over 50,000 people a month!

Share This Post

Report for matching names

For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/8bda0fe9-7d80-44d0-9a52-f1f573423abf/

 

select 
  CS.ResourceID,
  cs.NAME0,
  PC2.name0,
  substring(CS.NAME0,5,LEN(cs.NAME0))
from 
  dbo.v_GS_COMPUTER_SYSTEM CS,
  (select CS.ResourceID, cs.NAME0, substring(CS.NAME0,5,LEN(cs.NAME0)) as 'TAG' from  dbo.v_GS_COMPUTER_SYSTEM cS) as PC2
Where
  substring(CS.NAME0,5,LEN(cs.NAME0)) = PC2.Tag
  and PC2.Tag != ''
  and PC2.ResourceID != CS.ResourceID


Share This Post

Leave a Reply

Share This Post

Report for matching names

For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/8bda0fe9-7d80-44d0-9a52-f1f573423abf/

 

select 
  CS.ResourceID,
  cs.NAME0,
  PC2.name0,
  substring(CS.NAME0,5,LEN(cs.NAME0))
from 
  dbo.v_GS_COMPUTER_SYSTEM CS,
  (select CS.ResourceID, cs.NAME0, substring(CS.NAME0,5,LEN(cs.NAME0)) as 'TAG' from  dbo.v_GS_COMPUTER_SYSTEM cS) as PC2
Where
  substring(CS.NAME0,5,LEN(cs.NAME0)) = PC2.Tag
  and PC2.Tag != ''
  and PC2.ResourceID != CS.ResourceID


Share This Post