Role Definitions
Improved, additional or fixed role definitions for ConnectWise Automate. To import these Role Definitions, in the ConnectWise Automate main screen, go to Tools > Import then choose SQL File. Browse to the relevant file, and OK the message about inserting one row.
10 files
- 
Microsoft 365 - Azure AD Joined / Domain Joined / Hybrid AD Joined / On-Premises DRS Joined Role DefinitionsBy Gavsto These SQL files can be imported in System > General > Import > SQL File. It will add in four new role definitions
 Microsoft 365 - Azure AD Joined
 Microsoft 365 - Domain Joined
 Microsoft 365 - Hybrid AD Joined
 Microsoft 365 - On-Premises DRS Joined
 297 downloads (0 reviews)0 comments Submitted 
- 
TPM PresentBy Gavsto This SQL can be imported in System > General > Import > SQL File. It will add an additional role definition that detects when a TPM is present.
 217 downloads (0 reviews)0 comments Updated 
- 
Windows Server Backup RolesBy Gavsto This SQL can be imported in System > General > Import > SQL File. It will add an additional role definition that detects when a Windows Server Backup is scheduled on an agent. Note - it is possible to have the Windows Server Backup role installed, but without actually using its functionality to backup. This role definition will only detect when a backup has at some point been scheduled.
 88 downloads (0 reviews)0 comments Submitted 
- 
PowerShell Version RolesThis bundle will add the following Role Definition:
 PowerShell
 And the following Sub-Definitions:
 PowerShell 1
 PowerShell 2
 PowerShell 3
 PowerShell 4
 PowerShell 5
 PowerShell 6
 To import these Role Definitions, in the ConnectWise Automate main screen, go to Tools > Import -> SQL File. Browse to the relevant file, and OK the message about inserting 7 rows.
 
 397 downloads - role detection
- powershell
- (and 1 more)
 (0 reviews)0 comments Updated 
- 
Dell Server RolesThis bundle will create the following Role:
 Dell Server
 And the following sub-roles:
 Dell Server - 3G
 Dell Server - 4G
 Dell Server - 5G
 Dell Server - 6G
 Dell Server - 7G
 Dell Server - 8G
 Dell Server - 9G
 Dell Server - 10G
 Dell Server - 11G
 Dell Server - 12G
 Dell Server - 13G
 Dell Server - 14G
 Let me know if you find anything incorrectly detected, there are some odd ones prior to Gen10/11, and Gen14 is brand new so I have nothing in production to test against yet.
 To import these Role Definitions, in the ConnectWise Automate main screen, go to Tools > Import -> SQL File. Browse to the relevant file, and OK the message about inserting 13 rows.
 116 downloads 
- 
HP Proliant Server RolesThis bundle will create the following Role:
 HP Server
 And the following sub-roles:
 HP Server - Gen6
 HP Server - Gen7
 HP Server - Gen8
 HP Server - Gen9
 HP Server - Gen10
 I don't do a lot with HP servers, so these roles are not heavily tested. If you see anything detected incorrectly, please let me know so that I can update the role detection definition.
 To import these Role Definitions, in the ConnectWise Automate main screen, go to Tools > Import -> SQL File. Browse to the relevant file, and OK the message about inserting 6 rows.
 119 downloads - role definition
- role detection
- (and 3 more)
 
- 
Bitlocker EnabledBy Gavsto This role definition detects when Bitlocker is enabled on a machine.
 To import these Role Definitions, in the ConnectWise Automate main screen, go to Tools > Import then choose SQL File. Browse to the relevant file, and OK the message about inserting one row.
 1468 downloads 
- 
Backup AssistBy Gavsto This role definition checks for the installation of Backup Assist on an agent by detecting whether the Backup Assist service exists.
 To import these Role Definitions, in the ConnectWise Automate main screen, go to Tools > Import then choose SQL File. Browse to the relevant file, and OK the message about inserting one row.
 22 downloads (0 reviews)0 comments Updated 
- 
Windows Hyper-V Replication EnabledBy Gavsto This role definition detects, using the Hyper-V role as a parent role, any Hyper-V server that has replication enabled. This then is used in a search that populates a group I have full of tests to ensure replication is healthy.
 To import these Role Definitions, in the ConnectWise Automate main screen, go to Tools > Import then choose SQL File. Browse to the relevant file, and OK the message about inserting one row.
 127 downloads - hyper-v
- hyper-v replication
- (and 1 more)
 

 
	 
	 
	 
	 
	 
	 
	 
	 
	