![]() V_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 as 'AssignedSite', MAX (v_GS_NETWORK_ADAPTER_CONFIGUR.MACAddress0) as 'MACAddress', ISNULL(NULLIF(CHARINDEX(',',MAX(v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0)) - 1, -ġ),LEN(MAX(v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0))))as 'IPAddress', LEFT(MAX(v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0), When v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = 24 Then 'Sealed-Case PC' ![]() When v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = 23 Then 'Rack Mount Chassis' When v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = 22 Then 'Storage Chassis' When v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = 21 Then 'Peripheral Chassis' When v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = 17 Then 'Main System Chassis' When v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = 15 Then 'Space-Saving' When v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = 13 Then 'All in One' When v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = 7 Then 'Tower' ![]() When v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = 6 Then 'Mini Tower' When v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 IN('3','4')Then 'Desktop' This should give you all the info for your Dell Computersĭistinct (VRS.Netbios_Name0) as 'Computer Name',Ĭase when VRS.Client0 = 1 Then 'Yes' Else 'No' End 'Client',Ĭase when VRS.Active0 = 1 Then 'Yes' Else 'No' End 'Active',Ĭase when v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = 1 Then 'VMWare' Know this is an old post, but its good for anyone looking for a SQL query ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |