v_xr_computers_excel

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ReportCompanyName MEDIUMTEXT 16777215 null
ClientID INT 10 0
ClientName VARCHAR 50
ClientCompany VARCHAR 100
ClientArea VARCHAR 52
LocationID INT 10 0
LocationName VARCHAR 50 null
LocationArea VARCHAR 52
ComputerID INT 10 0
ComputerName VARCHAR 50 null
ComputerFriendlyName LONGTEXT 2147483647 null
ComputerRoles TEXT 65535 null
ComputerFormFactor VARCHAR 11
ComputerIsServer TINYINT 3 null
ComputerIsVirtual INT 10 0
ComputerChassisType VARCHAR 255 null
ComputerOSType VARCHAR 7
ComputerOS VARCHAR 255 null
ComputerServicePack DECIMAL 5,2 null
ComputerOSFullVersion VARCHAR 255 null
ComputerNETVersion VARCHAR 50 null
ComputerOSBranchReadinessLevel INT 10 0
ComputerServicePackName VARCHAR 255 null
ComputerAssetTag VARCHAR 100
ComputerSerial VARCHAR 100 null
ComputerManufacturer VARCHAR 255 null
ComputerModel VARCHAR 255 null
ComputerMAC VARCHAR 50 null
ComputerLocalIP VARCHAR 30 null
ComputerRouterIP VARCHAR 30 null
ComputerDomain VARCHAR 100 null
ComputerDNSInfo VARCHAR 500 null
ComputerLTVersion VARCHAR 8 null
ComputerAgentVersion VARCHAR 8 null
ComputerDateOSStart DATETIME 19 null
ComputerDateAgentAdded DATETIME 19 null
ComputerDateAddedLT DATETIME 19 null
ComputerDateLastContact DATETIME 19 null
ComputerUsername TEXT 65535 null
ComputerUptime BIGINT 19 null
ComputerCPUSpeed INT 10 null
ComputerCPUUsage INT 10 null
ComputerRAMSize INT 10 null
ComputerRAMFree INT 10 null
ComputerDriveSize DECIMAL 36,4 null
ComputerDriveFree DECIMAL 36,4 null
ComputerShares VARCHAR 500 null
ComputerFlags INT 10 null
ComputerContactID INT 10 null
ComputerContactName VARCHAR 101 null
ComputerContactArea VARCHAR 62 null
ComputerAVScannerName VARCHAR 50 null
ComputerAVAPSetting TINYINT 3 null
ComputerAVVirusDefs DATE 10 null

View Definition