Hardware Asset per Location sql query ?

Stephane_BouillonStephane_Bouillon Customer IT Monkey ✭
Hi, I'm writing a report on our hardware assets, and I would like to join the asset to the location it is related to. What I have so far is
SELECT HWA.Name_8B938849_A621_7754_D33B_BD8E54DC10B4 as [Asset], 
CASE WHEN HWA.ObjectStatus_4AE3E5FE_BC03_1336_0A45_80BF58DEE57B = 'acdcedb7-100c-8c91-d664-4629a218bd94' THEN 'Deployed'
ELSE 'Other'
END as [Status],
Manufacturer_C022FE4D_F552_A5A7_15BE_2B1BB900E9A6 as [Manufacturer], Model_A2D42F16_E0FC_C126_4460_F3A252B7C9EF as [Model],
YEAR(ReceivedDate_F3EA1950_6656_8251_AB6B_89372E4878DE) as [Year],
ReceivedDate_F3EA1950_6656_8251_AB6B_89372E4878DE as [Received]
FROM MT_Cireson$AssetManagement$HardwareAsset HWA
I would also like to include the warranty start and end dates and the catalog item fields

Best Answers


  • Stephane_BouillonStephane_Bouillon Customer IT Monkey ✭
    Great ! Thanks Geoff. Where can I find the table names ? Also, I found the asset type in the HardwareAssetType_07E9CFB0_049C_855E_D6CA_135808C8B964 column, how can I translate that to its display value ?
  • Stephane_BouillonStephane_Bouillon Customer IT Monkey ✭
    Interesting, would that be more performant as well ?
Sign In or Register to comment.