Routines

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