Home Asset Management

SQL Query for Assets Primary User

Cody_MathisCody_Mathis Customer IT Monkey ✭
Hello, I'm looking to query for the Hardware Assets primary user but I'm not really seeing where this might be in the tables. Any tips?

Best Answer


  • james_kleinschnitzjames_kleinschnitz Cireson Dev, Product Owner Advanced IT Monkey ✭✭✭
    What databases are you looking in?
  • Cody_MathisCody_Mathis Customer IT Monkey ✭
    I've been looking in both ServiceManager and ServiceManagement. I see the Cireson Hardware Asset table, but no columns seem to fit the bill. I see some potential columns I could use to join to another table, but I'm not so sure where the data is that I want to join to.
Sign In or Register to comment.