MSPBots WIKI : IT Glue Public Datasets
Here are the published or alpha version IT Glue datasets that you can use to create the widgets and dashboards.
In total, there are 14 publish/alpha Datasets
Name | Description | Created Date | Last updated | Fields |
---|---|---|---|---|
IT Glue Organizations - API | ODS Dataset which generated from IT Glue Organizations | May 25, 2022 | May 25, 2022 | ["id", "tenant_code", "sync_time", "organization_id", "psa_integration", "name", "alert", "description", "organization_type_id", "organization_type_name", "organization_status_id", "organization_status_name", "my_glue_account_id", "attributes_primary", "quick_notes", "quick_note_vault_id", "short_name", "created_at", "updated_at", "my_glue_account_status", "logo", "has_personal_passwords", "relationships"] |
IT Glue Users - API | ODS Dataset which generated from IT Glue Users | May 25, 2022 | May 25, 2022 | ["id", "tenant_code", "sync_time", "user_id", "first_name", "last_name", "name", "role_name", "email", "invitation_sent_at", "invitation_accepted_at", "current_sign_in_at", "current_sign_in_ip", "last_sign_in_at", "last_sign_in_ip", "reputation", "created_at", "updated_at", "my_glue_account_id", "avatar", "my_glue"] |
IT Glue Metrics - API | ODS Dataset which generated from IT Glue Metrics | May 25, 2022 | May 25, 2022 | ["id", "tenant_code", "sync_time", "metrics_id", "user_id", "organization_id", "created", "viewed", "edited", "deleted", "date", "resource_type"] |
ITGlue User Metric Data | Pulls in counts for actions related to documents and splits it out per user, organization, and document type. Data from last 365 days. Also assigns a score for each attribute. Score comes from the default IT Glue setup: creating: 10 editing: 5 viewing: 1 | May 26, 2022 | Dec 10, 2022 | ["id", "edited", "edited_score", "created", "created_score", "deleted", "net_new", "resource_type", "date", "viewed", "viewed_score", "total_score", "organization_id", "user_id", "organization", "organization_status", "user_name", "user_role", "organization_type", "identifier"] |
IT Glue Flexible Assets - API | ODS Dataset which generated from IT Glue Flexible Assets | Jul 04, 2022 | Jul 04, 2022 | ["id", "tenant_code", "sync_time", "other_id", "type", "organization_id", "organization_name", "resource_url", "restricted", "my_glue", "psa_integration", "flexible_asset_type_id", "flexible_asset_type_name", "name", "traits_name", "traits_category", "traits_version", "traits_seats", "traits_importance", "traits_business_impact", "traits_vendor_software_support_contact_details", "traits_license_keys", "traits_what_are_comvision_responsible_for", "traits_installation_location", "traits_additional_notes", "traits_what_machines_have_the_software_installed_type", "traits_what_machines_have_the_software_installed_values", "traits_application_contact_type", "traits_application_contact_values", "archived", "created_at", "updated_at", "relationships_adapters_resources_data"] |
ITGlue User Data | Information on the users setup within your IT Glue account | Jul 19, 2022 | Dec 10, 2022 | ["id", "last_updated", "user_name", "invitation_accepted_at", "last_signin_started_at", "created_at", "reputation", "role", "current_signin_started_at", "email", "current_signin_ip", "last_signin_ip"] |
ITGlue Configuration Data | This pulls in information on all configurations within your account | Jul 22, 2022 | Jun 08, 2023 | ["id", "last_update", "warranty_expiration", "warranty_status", "serial_number", "asset_tag", "purchased_by", "installed_at", "os_notes", "host_name", "mac_address", "manufacturer", "location", "organization", "configuration_type", "os_name", "model", "configuration", "configuration_status", "installed_by", "primary_ip", "purchased_at", "created_at", "position", "organization_short_name", "organization_type", "psa_sync_status", "organization_id"] |
IT Glue Contacts - API | ODS Dataset which generated from IT Glue Contacts | Apr 25, 2023 | Apr 25, 2023 | ["id", "tenant_code", "other_id", "organization_id", "type", "organization_name", "resource_url", "restricted", "psa_integration", "my_glue", "name", "first_name", "last_name", "title", "contact_type_id", "contact_type_name", "location_id", "location_name", "important", "notes", "created_at", "updated_at", "contact_emails", "contact_phones", "relationships_adapters_resources_data", "relationships_location_id", "relationships_location_type", "sync_time"] |
IT Glue SSL Certificates | This dataset lists the SSL Certificates that are associated to an organization along with their additional details. | Aug 22, 2023 | Sep 23, 2023 | ["id", "type", "organization_id", "organization_name", "resource_url", "restricted", "my_glue", "name", "host", "issued_by", "valid_until", "created_at", "updated_at", "signature_algorithm", "issuer_organization", "issuer_country", "issuer_state_province", "issuer_locality", "notes", "relationships_location_id", "relationships_location_type"] |
IT Glue Ssl Certificates - API | ODS Dataset which generated from IT Glue Ssl Certificates | Aug 23, 2023 | Aug 23, 2023 | ["id", "tenant_code", "sync_time", "other_id", "type", "organization_id", "organization_name", "resource_url", "restricted", "my_glue", "name", "host", "issued_by", "valid_until", "created_at", "updated_at", "signature_algorithm", "issuer_organization", "issuer_country", "issuer_state_province", "issuer_locality", "notes", "relationships_location_id", "relationships_location_type"] |
IT Glue Configurations | IT Glue dataset of the Configurations | Aug 23, 2023 | Sep 23, 2023 | ["id", "last_update", "warranty_expiration", "serial_number", "asset_tag", "purchased_by", "installed_at", "os_notes", "host_name", "mac_address", "manufacturer", "location", "organization", "configuration_type", "os_name", "model", "configuration", "configuration_status", "installed_by", "primary_ip", "purchased_at", "created_at", "position", "organization_short_name", "organization_type", "psa_sync_status"] |
IT Glue Office 365 Licenses | IT Glue dataset of the Office 365 Licenses page | Aug 23, 2023 | Jan 16, 2024 | ["id", "organization_name", "flexible_asset_type", "description", "organization_type", "organization_status_name", "product_name", "created_at", "updated_at", "resource_url", "my_glue", "my_glue_account_id", "my_glue_account_status", "psa_integration", "restricted", "traits_name", "traits_license_keys", "traits_category", "traits_application_contact_type", "traits_application_contact_values", "traits_additional_notes", "traits_importance", "attributes_primary", "quick_note_vault_id", "alert", "has_personal_passwords", "logo", "relationships", "attributes_traits_active", "attributes_traits_consumed", "attributes_traits_unused", "attributes_traits_licensed_users_type", "mapped_company_name"] |
IT Glue Locations - API | ODS Dataset which generated from IT Glue Locations | Oct 12, 2023 | Oct 12, 2023 | ["id", "tenant_code", "other_id", "organization_id", "country_id", "postal_code", "region_id", "mspbots_hash", "latitude", "longitude", "type", "organization_name", "resource_url", "restricted", "psa_integration", "my_glue", "name", "primarys", "address1", "address2", "city", "region_name", "country_name", "phone", "fax", "notes", "created_at", "updated_at", "formatted_phone", "formatted_fax", "relationships_adapters_resources_data", "sync_time"] |
IT Glue Location Data | IT Glue Location Data | Oct 13, 2023 | Nov 13, 2023 | ["id", "type", "last_update", "organization", "location_name", "attributes_address_1", "attributes_address_2", "attributes_city", "attributes_postal_code", "region", "country", "attributes_phone", "attributes_created_at", "attributes_primary"] |