Home Asset Management

Hardware Asset per Location sql query ?

Stephane_BouillonStephane_Bouillon Customer Adept 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], 
I would also like to include the warranty start and end dates and the catalog item fields

Best Answers

Answers

  • Stephane_BouillonStephane_Bouillon Customer Adept 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 Adept IT Monkey ✭✭
    Interesting, would that be more performant as well ?
Sign In or Register to comment.