Cloud services assigned users details

Analyze cloud services detail.

This query lists all users with their assigned cloud services and licensing plans. It includes information about the cloud provider, account, and service plan. The query allows filtering by cloud provider, account, and licensing plan. It also provides options to include disabled services and select specific organizations.

Fields

Name	Type	Visible	Description
Organization ID	numeric	false	Internal ID that references the Organization entity (Foreign Key)
Organization Guid	guid	false
Organization	string	true	Name of the organization
Organization Description	string	false	Description
Organization Custom Field1	string	false	Available for custom data, not used by OctoSAM Inventory,
Organization Custom Field2	string	false	Available for custom data, not used by OctoSAM Inventory,
Organization Custom Field3	string	false	Available for custom data, not used by OctoSAM Inventory,
Organization Custom Field4	string	false	Available for custom data, not used by OctoSAM Inventory,
Object State ID	numeric	false	Internal ID that references the ObjectState entity (Foreign Key)
Object State	string	false	Object state name
Object State Octopus Id	string	false	Octopus technical name of this state
User ID	numeric	false	Internal ID for the User entity (Primary Key)
User Guid	guid	false	A unique ID that can be used to link to this user object by external applications,
User	string	true	Combination of attributes for consisten naming on screen or in reports
Login Name	string	false	SAMAccount name,
Domain Name	string	false	Domain of the logged on user,
Display Name	string	false	DisplayName attribute from the directory service,
User Description	string	false	Description attribute from the directory service,
Directory Employee ID	string	false	EmployeeID attribute from Active Directory (updated on import and housekeeping)
Directory Company	string	false	Directory attribute from Active Directory
Directory Mail	string	false	Mail attribute from Active Directory
Directory Telephone Number	string	false	TelephoneNumber attribute from Active Directory
Directory Postal Code	string	false	PostalCode attribute from Active Directory
Directory City	string	false	City attribute from Active Directory
Directory Street	string	false	Street attribute from Active Directory
Directory Street Address	string	false	StreetAddress attribute from Active Directory
Directory Department	string	false	Department from Active Directory
Directory Department Number	string	false	DepartmentNumber from Active Drectory
Directory Physical Delivery Office Name	string	false	PhysicalDeliveryOfficeName attribute from Active Directory
User Principal Name	string	true	UserPrincipalName from the directory service,
Printable Name	string	false	Combination of attributes for consisten naming on screen or in reports
First Scan	date	false	Date/Time this user was scanned first
User Last Scan	date	true	Date/Time this user was scanned last
Deleted In Directory	bool	false	True, if the user object was deleted from the directory.
Deleted In Directory First Detected	date	false	Date/Time the DeletedInDirectory flag was set,
Last Found In Directory	date	false	Date/Time the user object was last found in Active Directory,
Last Found In Entra ID	date	false	Date/Time this user was last found in Entra ID
Directory Path	string	false	Path of the user object in the directory service
Directory Container Path	string	false	Path to the container objct of this user
Directory Extension Attribute1	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute2	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute3	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute4	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute5	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute6	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute7	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute8	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute9	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute10	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute11	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute12	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute13	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute14	string	false	ExtensionAttribute from Active Directory
Directory Extension Attribute15	string	false	ExtensionAttribute from Active Directory
Directory Last Logon Timestamp	date	false	LastLogonTimestamp attribute from Active Directory (updated on import and housekeeping). Resolution: 14 days.
Directory Preferred Language	string	false	User's preferred language from ActiveDirectory
Directory When Created	date	false	WhenCreated attribute from Active Directory
Directory When Changed	date	false	WhenChanged attribute from Active Directory (updated on import and housekeeping)
Directory User Account Control	numeric	false	UserAccountControl attribute from Active Directory (updated on import and housekeeping)
Directory Disabled	bool	false	True if the UserAccountControl attribute has the disable bit set
Directory Type	string	false	Directory type that this user was found in.,
Entra Id Cost Center	string	false	Cost center from Entra ID
Entra Id Creation Type	string	false	Entra ID creation type
Entra Id Created Date Time	date	false	Date/Time created in Entra ID
Entra Id Deleted Date Time	date	false	Date/Time this user object was deleted in Azure AD
Entra Id Division	string	false	Division from Entra ID
Entra Id Employee Hire Date	date	false	Date this employee was hired
Entra Id Employee Leave Date Time	date	false	Date/Time this employee was left or will leave
Entra Id Given Name	string	false	Given name of the user
Entra Id On Premises Distinguished Name	string	false	Distinguished name that got replicated from on-site to Entra ID
Entra Id On Premises Domain Name	string	false	Domain name that got replicated from on-site to Entra ID
Entra Id On Premises Last Sync Date Time	date	false	Date/Time this object was last synchronized from on-site AD
Entra Id On Premises Sync Enabled	bool	false	If true the user object gets synchronized from an on-size AD
Entra Id On Premises User Principal Name	string	false	UPN that got synchronized from on-prem AD
Entra Id Preferred Data Location	string	false	Preferred data location from Entra ID
Entra Id Surname	string	false	Surname of the user
Entra Id Tenant Id	guid	false	Entra ID tenant Id
Entra Id User Type	string	false	Entra ID user type
Entra Id Last Sign In Date Time	date	false	Date/Time this user last signed in to Entra ID. This information may not be available depending on your Entra ID license.
Entra Id Last Non Interactive Sign In Date Time	date	false	Date/Time of the last non-interactive sign in to Entra ID. This information may not be available depending on your Entra ID license.
Mapping Tag	string	false	A field that can be used for custom organization mapping
Cloud Provider ID	numeric	false	OctoSAM internal ID of the cloud provider
Cloud Provider	string	false	Name of a cloud provider
Account ID	numeric	false	OctoSAM internal ID of the cloud provider account
Account	string	false	Name of a cloud provider account
Account Entra Id Tenant Id	guid	false
Account Licensing Plan ID	numeric	false	OctoSAM internal ID of the cloud provider account licensing plan
Account Licensing Plan Sku	string	false	SKU of the licensing plan
Account Licensing Plan	string	true	Friendly name, code translation from the SKU if available, SKU otherwise
Account Licensing Plan Last Scan	date	false	Date/Time this account licensing plan got last scanned
Active Units	numeric	false	Number of active license units
Consumed Units	numeric	false	Number of license units consumed
Locked Out Units	numeric	false	Number of locked out license units
Warning Units	numeric	false	Number of license units that are in warning state
Service Plan ID	numeric	false	OctoSAM internal ID of the service plan
Service Plan Sku	string	false	SKU of the service,
Service Plan	string	true	Friendly name of the service if available by code translation, SKU otherwise
Provisioning Status	string	true	Provider dependent provisioning status,
User Account Licensing Plan Last Scan	date	false	Date/Time this relation got last scanned
User Service Last Scan	date	false	Date/Time this relation got last scanned,
Current Date Time	date	false	Date and time the query was run. For reference if you use and save query results.

Main entities referenced from this query

• User

• CloudProviderAccountLicensingPlan

• UserCloudProviderAccountLicensingPlanCloudProviderService

Query information

Property	Value	Description
Query Guid	5f3ff3fb-4874-4451-8bdc-4ac96748948d	The internal id of the query. Must be unique
SupportsDesktop	true	If true, the query can be started from the OctoSAM Windows GUI
SupportsWeb	true	If true, the query can be started from the OctoSAM Web UI