Routines
| Name | Type | Language | Deterministic | Return Type | Security Restriction | Comments |
|---|---|---|---|---|---|---|
| FillAgentComputers | PROCEDURE | SQL | false | DEFINER | ||
| sp_ComputerFastSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| sp_FixMasterGroups | PROCEDURE | SQL | false | DEFINER | ||
| sp_RunCommandClient | PROCEDURE | SQL | false | DEFINER | ||
| sp_DoAllClients | PROCEDURE | SQL | false | DEFINER | ||
| sp_UpdateHotfixOSData | PROCEDURE | SQL | false | DEFINER | ||
| sp_insert_ind_data | PROCEDURE | SQL | false | DEFINER | ||
| sp_AuditProcess | FUNCTION | SQL | false | varchar(10000) | DEFINER | |
| sp_AutoRemoveComputersMasterTrump | PROCEDURE | SQL | false | DEFINER | ||
| sp_ResetCommand | PROCEDURE | SQL | false | DEFINER | ||
| v_ExtraDataRefresh | PROCEDURE | SQL | false | DEFINER | ||
| EventScore | FUNCTION | SQL | true | int | DEFINER | |
| sp_SoftwareSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| PopulateCacheEventDates | PROCEDURE | SQL | false | DEFINER | ||
| sp_DoApplyManagedServices | PROCEDURE | SQL | false | DEFINER | ||
| sp_AutoJoin | PROCEDURE | SQL | false | DEFINER | ||
| TicketScore | FUNCTION | SQL | true | int | DEFINER | |
| sp_GetSAPReportData | PROCEDURE | SQL | false | DEFINER | ||
| sp_AutoJoinNetworkDevices | PROCEDURE | SQL | false | DEFINER | ||
| ISNUMERIC | FUNCTION | SQL | true | tinyint(1) | DEFINER | |
| sp_ContactSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| sp_RunCommandSearch | PROCEDURE | SQL | false | DEFINER | ||
| sp_NetworkDeviceSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| sp_DeleteUser | PROCEDURE | SQL | false | DEFINER | ||
| sp_DeleteGroup | PROCEDURE | SQL | false | DEFINER | ||
| sp_RunCommandGroup | PROCEDURE | SQL | false | DEFINER | ||
| BASE64_ENCODE | FUNCTION | SQL | true | blob | INVOKER | |
| VirusScore | FUNCTION | SQL | true | int | DEFINER | |
| DriveScore | FUNCTION | SQL | true | int | DEFINER | |
| sp_PasswordSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| sp_TicketSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| CleanupCacheEventDates | PROCEDURE | SQL | false | DEFINER | ||
| f_GroupFullName | FUNCTION | SQL | true | varchar(2000) | DEFINER | |
| sp_ProductkeySimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| sp_LocationSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| sp_SetDBVar | PROCEDURE | SQL | false | DEFINER | ||
| sp_SetConfig | PROCEDURE | SQL | false | DEFINER | ||
| sp_UpdateTemplate | PROCEDURE | SQL | false | DEFINER | ||
| charsplit | FUNCTION | SQL | true | varchar(255) | DEFINER | |
| sp_AutoJoinComputersFromContacts | PROCEDURE | SQL | false | DEFINER | Join Computers into groups |
|
| FillCompStatsHourlyGaps | PROCEDURE | SQL | false | DEFINER | ||
| sp_FindSearches | PROCEDURE | SQL | false | DEFINER | ||
| sp_CleanupNetworkDevices | PROCEDURE | SQL | false | DEFINER | ||
| BASE64_DECODE | FUNCTION | SQL | true | blob | INVOKER | |
| f_fragmentation | FUNCTION | SQL | true | int | DEFINER | |
| sp_SplitSetToTempTable | PROCEDURE | SQL | false | DEFINER | ||
| sp_RunMicrosoftNonCompliantPatchCounts | PROCEDURE | SQL | false | DEFINER | ||
| sp_RunPatchReportCalculations | PROCEDURE | SQL | false | DEFINER | ||
| sp_UpdateAutoIncrements | PROCEDURE | SQL | false | DEFINER | ||
| HVDataBulkInsert | PROCEDURE | SQL | false | DEFINER | ||
| sp_VEventLogs | PROCEDURE | SQL | true | DEFINER | ||
| sp_DeleteComputer | PROCEDURE | SQL | false | DEFINER | ||
| sp_GetAvailableLicense | PROCEDURE | SQL | false | DEFINER | ||
| PopulateSystemEventDates | PROCEDURE | SQL | false | DEFINER | ||
| FormatOsForPatching | FUNCTION | SQL | true | varchar(255) | DEFINER | |
| sp_ClientSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| sp_RunCommandAll | PROCEDURE | SQL | false | DEFINER | ||
| PatchScore | FUNCTION | SQL | true | int | DEFINER | |
| sp_AutoJoinContacts | PROCEDURE | SQL | false | DEFINER | ||
| OSScore | FUNCTION | SQL | true | int | DEFINER | |
| sp_GetMobileGroupPolicy | PROCEDURE | SQL | true | DEFINER | ||
| sp_LinkedGroups | PROCEDURE | SQL | false | DEFINER | ||
| AvailScore | FUNCTION | SQL | true | int | DEFINER | |
| PerfScore | FUNCTION | SQL | true | int | DEFINER | |
| sp_split | PROCEDURE | SQL | false | DEFINER | ||
| sp_DoSubGroupChildren | PROCEDURE | SQL | false | DEFINER | ||
| substrCount | FUNCTION | SQL | true | int | DEFINER | |
| sp_CalculateHotfixPatchSummaryData | PROCEDURE | SQL | false | DEFINER | ||
| sp_ComputerSimpleSearch | PROCEDURE | SQL | true | DEFINER | ||
| f_Username | FUNCTION | SQL | true | varchar(100) | DEFINER | |
| HealthScore | FUNCTION | SQL | true | int | DEFINER | |
| v_ExtraDataRefreshComputers | PROCEDURE | SQL | false | DEFINER | ||
| sp_CheckIn | PROCEDURE | SQL | false | DEFINER | ||
| sp_SecurityTokenCleanup | PROCEDURE | SQL | false | DEFINER | Clears out old and disabled security tokens |
|
| f_VersionCompare | FUNCTION | SQL | true | int | DEFINER | |
| v_extradata | PROCEDURE | SQL | false | DEFINER | ||
| stringSplit | FUNCTION | SQL | true | varchar(255) | DEFINER | |
| sp_GetCommands | PROCEDURE | SQL | false | DEFINER | ||
| sp_RunCommandLocation | PROCEDURE | SQL | false | DEFINER | ||
| CleanupSystemEventDates | PROCEDURE | SQL | false | DEFINER | ||
| HVDataInsert | PROCEDURE | SQL | false | DEFINER | ||
| sp_UpdateOperatingSystemPatchFilterItems | PROCEDURE | SQL | false | DEFINER | ||
| sp_AddUpdateRoleDefinition | PROCEDURE | SQL | false | DEFINER | ||
| f_getEFD | FUNCTION | SQL | false | longtext | DEFINER | |
| sp_UpdateUserSec | PROCEDURE | SQL | false | DEFINER | ||
| LT_CompareVersions | FUNCTION | SQL | true | int | DEFINER | |
| CleanupUserLockout | PROCEDURE | SQL | false | DEFINER |