Tuesday, October 21, 2014

servers with Mac address Report

SQL :



Select distinct
      v_R_System.Netbios_Name0,
      v_RA_System_MACAddresses.MAC_Addresses0
from
    v_R_System, v_R_System SYS, v_RA_System_MACaddresses,
    v_fullcollectionmembership
where
    v_ra_system_macaddresses.resourceid=v_r_system.resourceid
    and v_fullcollectionmembership.resourceid=v_ra_system_macaddresses.resourceid
    and SYS.resourceid=v_r_system.resourceid
and v_R_System.Operating_System_Name_and0 LIKE '%server%'

No comments:

Post a Comment