Metrics Library

Returns a List of all ITGlue Organizations Organizations[].Name

Returns a list of all ITGlue organizations with their current assigned status and type Organizations[].[Name, OrganizationTypeName, OrganizationStatusName]

Returns a list of all Enabled ITGlue Flexible Assets FlexibleAssetTypes[?Enabled == true ].Name

Returns a list of all Disabled ITGlue Flexible Assets FlexibleAssetTypes[?Enabled == false ].Name

Returns a list of ITGlue Administrative Users Users[?RoleName == Administrator ].Name

Returns a list of all ITGlue Users (Admins Excluded) Users[?RoleName != Administrator ].Name

Returns a List of all ITGlue Flexible Assets FlexibleAssetTypes[].Name

Output will be ["Administrator Name", "Next Admin"]. Users[? RoleName == 'Administrator'].Name

When you have a lot of IT Glue accounts it can be hard to know which are no longer needed, since you are not able to easily filter by Last Login Date. This metric can help review IT Glue users and excludes the My Glue accounts and Lite accounts. Users[?LastSignInAt && time_since(LastSignInAt, days ) > 90 && MyGlueAccountId == null && RoleName != 'Lite'].join(' | Days Since Last Log In: ', [Email, to_string(time_since(LastSignInAt, days ))])

Returns a list of users who haven't signed in for more than 90 days.To only return Lite users (Or another specific type of user, add the following after the first "[": RoleName == Lite &&Change the 90 to however many days you want to monitor Users[? LastSignInAt && time_since(LastSignInAt, days ) > 90 ].join(' | Days Since Last Log In: ', [Email, to_string(time_since(LastSignInAt, days ))])