Routines
| Name | Type | Language | Deterministic | Return Type | Security Restriction | Comments |
|---|---|---|---|---|---|---|
| AvailScore | FUNCTION | SQL | true | int(11) | DEFINER | |
| BASE64_DECODE | FUNCTION | SQL | true | blob | INVOKER | |
| BASE64_ENCODE | FUNCTION | SQL | true | blob | INVOKER | |
| charsplit | FUNCTION | SQL | true | varchar(255) | DEFINER | |
| CleanupCacheEventDates | PROCEDURE | SQL | false | DEFINER | ||
| CleanupSystemEventDates | PROCEDURE | SQL | false | DEFINER | ||
| CleanupUserLockout | PROCEDURE | SQL | false | DEFINER | ||
| DriveScore | FUNCTION | SQL | true | int(11) | DEFINER | |
| EventScore | FUNCTION | SQL | true | int(11) | DEFINER | |
| f_fragmentation | FUNCTION | SQL | true | int(11) | DEFINER | |
| f_getEFD | FUNCTION | SQL | false | longtext | DEFINER | |
| f_GroupFullName | FUNCTION | SQL | true | varchar(2000) | DEFINER | |
| f_Username | FUNCTION | SQL | true | varchar(100) | DEFINER | |
| f_VersionCompare | FUNCTION | SQL | true | int(11) | DEFINER | |
| FillAgentComputers | PROCEDURE | SQL | false | DEFINER | ||
| FillCompStatsHourlyGaps | PROCEDURE | SQL | false | DEFINER | ||
| FormatOsForPatching | FUNCTION | SQL | true | varchar(255) | DEFINER | |
| HealthScore | FUNCTION | SQL | true | int(11) | DEFINER | |
| HVDataBulkInsert | PROCEDURE | SQL | false | DEFINER | ||
| HVDataInsert | PROCEDURE | SQL | false | DEFINER | ||
| ISNUMERIC | FUNCTION | SQL | true | tinyint(1) | DEFINER | |
| LT_CompareVersions | FUNCTION | SQL | true | int(11) | DEFINER | |
| OSScore | FUNCTION | SQL | true | int(11) | DEFINER | |
| PatchScore | FUNCTION | SQL | true | int(11) | DEFINER | |
| PerfScore | FUNCTION | SQL | true | int(11) | DEFINER | |
| PopulateCacheEventDates | PROCEDURE | SQL | false | DEFINER | ||
| PopulateSystemEventDates | PROCEDURE | SQL | false | DEFINER | ||
| sp_AddUpdateRoleDefinition | PROCEDURE | SQL | false | DEFINER | ||
| sp_AuditProcess | FUNCTION | SQL | false | varchar(10000) | DEFINER | |
| sp_AutoJoin | PROCEDURE | SQL | false | DEFINER | ||
| sp_AutoJoinComputersFromContacts | PROCEDURE | SQL | false | DEFINER | Join Computers into groups |
|
| sp_AutoJoinContacts | PROCEDURE | SQL | false | DEFINER | ||
| sp_AutoJoinNetworkDevices | PROCEDURE | SQL | false | DEFINER | ||
| sp_AutoRemoveComputersMasterTrump | PROCEDURE | SQL | false | DEFINER | ||
| sp_CalculateHotfixPatchSummaryData | PROCEDURE | SQL | false | DEFINER | ||
| sp_CheckIn | PROCEDURE | SQL | false | DEFINER | ||
| sp_CleanupNetworkDevices | PROCEDURE | SQL | false | DEFINER | ||
| sp_ClientSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| sp_ComputerFastSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| sp_ComputerSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| sp_ContactSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| sp_DeleteComputer | PROCEDURE | SQL | false | DEFINER | ||
| sp_DeleteGroup | PROCEDURE | SQL | false | DEFINER | ||
| sp_DeleteUser | PROCEDURE | SQL | false | DEFINER | ||
| sp_DoAllClients | PROCEDURE | SQL | false | DEFINER | ||
| sp_DoApplyManagedServices | PROCEDURE | SQL | false | DEFINER | ||
| sp_DoSubGroupChildren | PROCEDURE | SQL | false | DEFINER | ||
| sp_FindSearches | PROCEDURE | SQL | false | DEFINER | ||
| sp_FixMasterGroups | PROCEDURE | SQL | false | DEFINER | ||
| sp_FormatOSName | PROCEDURE | SQL | false | DEFINER |
Processing...