Home Asset Management

Consumables Activity Log

Gordon_KenmuirGordon_Kenmuir Customer IT Monkey ✭

Does anyone know the name of the table to which the data is written for consumable activity log entries that are captured when I increase or decrease consumable count through the task side bar?

I took a look through all the tables with the name consumable in them and could not find it

Answers

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭

    @Gordon_Kenmuir - The table you're looking for is MT_Cireson$AssetManagement$Log. Here's a query that might help get you started:

     SELECT 

     c.DisplayName AS 'Consumable', 

     l.Title_CECA6A53_340B_09C9_2DF6_961488EA8726 AS 'Title',

     l.Comment_D96EAD8E_588C_9FBD_6A92_B7E5DD0AB530 AS 'Comment',

     l.CreatedDate_F3F062B1_C9A3_EC91_2018_A3473B23012A AS 'AddedOn'

     FROM MT_Cireson$AssetManagement$Log l

     JOIN Relationship r

     ON r.TargetEntityId = l.BaseManagedEntityId

     and r.RelationshipTypeId = '8923DF94-9BE2-5F07-A112-73B1B754A1A4'

     JOIN MT_Cireson$AssetManagement$Consumable c

     ON r.SourceEntityId = c.BaseManagedEntityId

  • Gordon_KenmuirGordon_Kenmuir Customer IT Monkey ✭

    Justin, that would be awesome...except I am not seeing that table either in my Service Manager DW or the ServiceManagement DB

  • Shane_WhiteShane_White Cireson Support Super IT Monkey ✭✭✭✭✭

    @Gordon_Kenmuir

    In the Portal, when you go to Admin Settings -> Dynamic Data -> Configuration

    In the table, do you see an Entry for MT_Cireson$AssetManagement at all?

    Thanks,

    Shane

  • Gordon_KenmuirGordon_Kenmuir Customer IT Monkey ✭
    edited July 2020

    Shane, yes I see that there, but when I go to the Cireson portal DB, I don't see that available to get data from in Power Query. Not sure that makes sense?

  • Shane_WhiteShane_White Cireson Support Super IT Monkey ✭✭✭✭✭

    @Gordon_Kenmuir

    Are you talking about when you query it in SQL? You do not see the table:

    MT_Cireson$AssetManagement$Log

    Thanks,

    Shane

  • Gordon_KenmuirGordon_Kenmuir Customer IT Monkey ✭

    Yes that is correct, I don't see that table to query in SQL or in PowerQuery/PowerBI

Sign In or Register to comment.