LinkPoint installed machines report

    LinkPoint installed machines report :-




Select distinct sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0, arp.DisplayName0 ,
 v_R_User.Full_User_Name0, v_R_User.Mail0,arp.installdate0

 FROM v_r_system sys
 JOIN v_R_User on sys.User_Name0 = v_R_User.User_Name0
 JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
 JOIN v_FullCollectionMembership fcm on sys.ResourceID = fcm.ResourceID
 WHERE DisplayName0 like 'LinkPoint%'
 order by sys.Netbios_Name0