API Data Provider - Online Help
Samanage Profile
Connecting to Samanage
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
Audits
CatalogItems
Categories
Changes
ConfigurationItems
Contracts
Departments
Groups
Hardware
Incidents
MobileDevices
OtherAssets
Printers
Problems
PurchaseOrders
Releases
Risks
Roles
Sites
Software
Solutions
Users
Vendors
Warranties
Roles
Returns a list of all Roles.
Columns
Name
Type
References
Id [KEY]
Integer
Name
String
Portal
Boolean
ShowMyTasks
Boolean