When Operating_System_DATA.Caption00 = 'Microsoft(R) Windows(R) Server 2003, Standard Edition' Then 'Microsoft(R) Windows(R) Windows(R) Server 2003 Enterprise Edition' When v_GS_COMPUTER_SYSTEM.domainrole0 = 5 Then 'Primary Domain Controller'Ĭase when Operating_System_DATA.Caption00 = 'Microsoft(R) Windows(R) Server 2003, Enterprise Edition' Then 'Microsoft(R) When v_GS_COMPUTER_SYSTEM.domainrole0 = 4 Then 'Backup Domain Controller' When v_GS_COMPUTER_SYSTEM.domainrole0 = 3 Then 'Member Server' When v_GS_COMPUTER_SYSTEM.domainrole0 = 2 Then 'Standalone Server' When v_GS_COMPUTER_SYSTEM.domainrole0 = 1 Then 'Member Workstation' VRS.User_Domain0+'\'+ VRS.User_Name0 as 'UserName',Ĭase when v_GS_COMPUTER_SYSTEM.domainrole0 = 0 then 'Standalone Workstation' V_GS_COMPUTER_SYSTEM.Domain0 as 'DomainName', When Computer_System_DATA.Manufacturer00 like 'MICRO-STAR%' Then 'MICRO-STAR'Įlse Computer_System_DATA.Manufacturer00 End 'Manufacturer',Ĭomputer_System_DATA.SystemType00 as 'OSType', When Computer_System_DATA.Manufacturer00 like 'VIA Technologies%' Then 'VIA Technologies' When Computer_System_DATA.Manufacturer00 like 'Gigabyte%' Then 'Gigabyte' PC_BIOS_DATA.SMBIOSBIOSVersion00 as 'BiosVersion',Ĭase when Computer_System_DATA.Manufacturer00 like 'VMware%' Then 'VMWare' PC_BIOS_DATA.ReleaseDate00 as 'ReleaseDate', V_GS_SYSTEM_ENCLOSURE.SMBIOSAssetTag0 as 'AssetTag', PC_BIOS_DATA.SerialNumber00 as 'SerialNumber', VRS.Creation_Date0 as 'ClientCreationDate',ĭateDiff(D, VRS.Creation_Date0, GetDate()) 'ClientCreationDateAge',ĭbo.v_GS_OPERATING_SYSTEM.InstallDate0 AS 'OSInstallDate',ĭateDiff(D, v_GS_OPERATING_SYSTEM.InstallDate0, GetDate()) 'OSInstallDateAge',Ĭonvert(VarChar, v_Gs_Operating_System.LastBootUpTime0,100) as 'LastBootDate',ĭateDiff(D, Convert(VarChar, v_Gs_Operating_System.LastBootUpTime0,100), GetDate()) as 'LastBootDateAge', 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' Here are some recommended articles related to this topic that might be of interest to you.Know this is an old post, but its good for anyone looking for a SQL query Learn more about Using BIOSConnect to recover SupportAssist OS Recovery Partition.įigure 25: Cortana setup screen during the Windows first-time setup process. Dell BIOS Connect: Dell BIOSConnect helps you restore the recovery image on the hard drive if the recovery partition is corrupt or deleted.SupportAssist OS Recovery Local Restore: This option restores the computer from the recovery image that is stored in the computer's hard drive.SupportAssist OS Recovery Cloud Restore (Recommended): This option downloads and installs the latest version of the operating system on your Dell computer.Newer Dell computers support BIOSConnect, a feature that allows you to restore the recovery image on the hard drive. Learn more about Using BIOSConnect to recover SupportAssist OS Recovery Partition. Important: If the recovery image on the hard drive is corrupt or deleted, the computer cannot boot to the recovery environment. SupportAssist OS Recovery provides you with different options to recover your computer depending on the scenario you are facing. When available, closed caption (subtitles) language settings can be chosen using the Settings or CC icon on this video player.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |