Workaround Available

GS Asset Usage Tracking Object - New field requests

  • 20 September 2021
  • 5 replies
  • 43 views

Userlevel 7
Badge +2

I love the addition of this object for horizon analytics. One thing that would make a massive improvement on it is the inclusion of some kind of Active boolean field.

 

Essentially, I have a few reports based on this object that look at stale assets. What I’m now running into is that when a report or dashboard is deleted, it’s record still persists. This is fine, but now they’re showing up on my stale asset list because no one has used them which is obvious as they have been deleted.

 

I can filter them out manually, but that gets really clunky, especially if I’m filtering on asset name on a report level, but have an asset name global filter on a dashboard - that could potentially get me undesired results.

 

If assets were marked as Active = false when they were deleted, it would be an easy filter add to reports where you only wanted to look at usage for active assets. This would also allow you to retain some historical data for deleted assets.


5 replies

Userlevel 6

Hello @bradleymcg, thank you for your post and feedback on the enhancement of Horizon Analytics, looping in our Product Manager to look into your request and get back to you.

Userlevel 4

Hey @bradleymcg will attempt an inelegant solution as a stand in till we can add the column for status. ( ideally this is tracking for asset runs so may be that column might not make as much sense here ). 

To get the list of all asset types that were deleted - you can do that by adding a filter for event type contains delete. You can then use this in DD to transform the table with a case field and add a inactive column if the asset eve has a delete event associated to it. 

It’s not straight forward .. and we will work on closing the gap with this field added by default. 

 

Userlevel 7
Badge +2

Hey @bradleymcg will attempt an inelegant solution as a stand in till we can add the column for status. ( ideally this is tracking for asset runs so may be that column might not make as much sense here ). 

To get the list of all asset types that were deleted - you can do that by adding a filter for event type contains delete. You can then use this in DD to transform the table with a case field and add a inactive column if the asset eve has a delete event associated to it. 

It’s not straight forward .. and we will work on closing the gap with this field added by default. 

 

Thanks for providing a work around, not sure I’ll go that route until something else is available unless I need to :) I’m not sure I agree that a column doesn’t make sense - the use case is to easily filter out assets that are not in use, but the filter as at the asset level and not the event level. Maybe there’s a field called visibility that shows permission levels and availability, so you can filter out private assets, reports not consumed anywhere and deleted assets. 

Userlevel 7
Badge +2

@Azad  any update on if this will get added to the object anytime soon?  The workaround is not exactly ideal.

Userlevel 7
Badge +2

Related request but different fields to add to the request @Azad :

 

  • Asset Created Date: if you’re looking at poorly adopted assets then it is challenging to account for recencey bias against newly created reports, for example.
  • This one is more complicated and has more to do with permission reporting - but it would also be great to filter by permission bundle/group. Not everyone has access to the same assets and there is currently no way to account for that when using this object (that I can see). Even starting with a boolean Private = True/False would be useful so you can filter out private only reports and dashboards. 
    • I realize not all current and future assets will necessarily have a similar function, but some way to indicate if something is actually accessible to end-users and filter out things that are not would be great.

Reply