Page History
...
- Define variables for the computers that host the SQLcompliance Agent and the new Collection Server.
For example, if you plan to run a Visual Basic script locally on the computer that hosts the SQL Server, your script may include the following code:
' Define the SQL compliance manager Agent server strComputer = "SQLServer01" strNewCollectionServer = "CollectionServer02" Declare the SQLcompliance Agent and registry objects.
For example, if you plan to run a Visual Basic script locally on the computer that hosts the SQL Server, your script may include the following code:
' Get the SQLcompliance Agent and registry objects Set objComplianceAgent = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" _
& strComputer & "\root\cimv2:Win32_Service='SQLcomplianceAgent'")
Set objReg = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" _
& strComputer & "\root\default:StdRegProv")- Stop the SQLcompliance Agent Service.
For example, if you plan to run a Visual Basic script locally on the computer that hosts the SQL Server, your script may include the following code:
' Stop the SQLcompliance Agent Set flgStopStatus = objComplianceAgent.ExecMethod_("StopService") - Change the registry key.
For example, if you plan to run a Visual Basic script locally on the computer that hosts the SQL Server, your script may include the following code:
' Change the location of the Collection Server in the registry const HKEY_LOCAL_MACHINE = &H80000002 strRegAgentPath = "SOFTWARE\Idera\SQLcompliance\SQLcomplianceAgent" strServerValName = "Server" objReg.GetStringValue HKEY_LOCAL_MACHINE, strRegAgentPath, strServerValName, strOldServer objReg.SetStringValue HKEY_LOCAL_MACHINE, strRegAgentPath,strServerValName, strNewCollectionServer WScript.Echo "Changed collection server from " & strOldServer & " to " & strNewCollectionServer
- Start the SQLcompliance Agent Service.
For example, if you plan to run a Visual Basic script locally on the computer that hosts the SQL Server, your script may include the following code:
' Restart the SQLcompliance Agent Set flgStartStatus = objComplianceAgent.ExecMethod_("StartService") - Using an administrator account, run your script to update each SQLcompliance Agent deployed to your registered SQL Servers.
SQL Compliance Manager audits all activity on your server. Learn more > >