v_ltcr_assets

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ContactID

BIGINT

ClientID

INT

LocationID

INT

AssetID

BIGINT

AssetType

VARCHAR

View Definition

select `con`.`ContactID` AS `ContactID`,`cmp`.`ClientID` AS `ClientID`,`cmp`.`LocationID` AS `LocationID`,`cmp`.`ComputerID` AS `AssetID`,if(((locate('server',`cmp`.`OS`) > 0) or (locate('linux',`cmp`.`OS`) > 0)),'Server','Workstation') AS `AssetType` from (`labtech`.`contacts` `con` join `labtech`.`computers` `cmp` on((`con`.`ContactID` = `cmp`.`ContactID`))) union select -(1) AS `-1`,`cmp`.`ClientID` AS `ClientID`,`cmp`.`LocationID` AS `LocationID`,`cmp`.`ComputerID` AS `ComputerID`,if(((locate('server',`cmp`.`OS`) > 0) or (locate('linux',`cmp`.`OS`) > 0)),'Server','Workstation') AS `AssetType` from `labtech`.`computers` `cmp` where (`cmp`.`ContactID` <= 0) union select `con`.`ContactID` AS `ContactID`,`mob`.`ClientID` AS `ClientID`,`mob`.`LocationID` AS `LocationID`,`mob`.`MobileID` AS `MobileID`,'Mobile' AS `Mobile` from (`labtech`.`contacts` `con` join `labtech`.`mobiledevices` `mob` on((`con`.`ContactID` = `mob`.`ContactID`))) union select -(1) AS `-1`,`mob`.`ClientID` AS `ClientID`,`mob`.`LocationID` AS `LocationID`,`mob`.`MobileID` AS `MobileID`,'Mobile' AS `Mobile` from `labtech`.`mobiledevices` `mob` where (`mob`.`ContactID` <= 0) union select `con`.`ContactID` AS `ContactID`,`con`.`ClientID` AS `ClientID`,`con`.`LocationID` AS `LocationID`,0 AS `0`,'' AS `Blank` from ((`labtech`.`contacts` `con` left join `labtech`.`computers` `cmp` on((`con`.`ContactID` = `cmp`.`ContactID`))) left join `labtech`.`mobiledevices` `mob` on((`con`.`ContactID` = `mob`.`ContactID`))) where ((`cmp`.`ContactID` is null) and (`mob`.`ContactID` is null) and (`con`.`ContactID` <> 0))

Columns

View Definition

Possibly Referenced Tables/Views