v_xr_computers

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
UserID INT 10 0
ReportCompanyName MEDIUMTEXT 16777215 √ null
ClientID INT 10 0
ClientName VARCHAR 50
ClientCompany VARCHAR 100
ClientArea VARCHAR 52 √ null
LocationID INT 10 0
LocationName VARCHAR 50 null
LocationArea VARCHAR 52 √ null
ComputerID INT 10 0
ComputerName VARCHAR 50 null
ComputerFriendlyName LONGTEXT 2147483647 null
ComputerRoles VARCHAR 341 √ 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

Possibly Referenced Tables/Views