MyITGuy

for %%i in (concentr.exe,receiver.exe,redirector.exe,radeobj.exe,wfcrun32.exe,wfica32.exe,pnamain.exe) do (taskkill /im "%%i" /f)

MyITGuy

-- Splits a forward-slash delimited value using XML node names
-- COMPANY/COUNTRY/STATE_ABBR/CITY/OFFICE/BUILDING_CODE/NETWORK_TYPE
-- 1. Replace the forward-slash with the end tag and beginning of next tag '/><'
-- 2. Replace any space characters with an underscore character (Node names cannot contain spaces)
-- 3. Add tag start '<' to value
-- 4. Add tag end '/>' to value
-- 5. Cast value as XML
-- 6. Query XML for all node names, returning the 6th value (BUILDING_CODE)
-- 6. Case XML.query as VARCHAR
DECLARE @value VARCHAR(MAX)

MyITGuy

$OutputObjects = New-Object -TypeName PSObject
$OutputObjects = @()

$Objects = Get-CimInstance -Class Win32_Service

foreach ($Object In $Objects) {
  $Name = $Object.Name
  $OutputObject = New-Object -TypeName PSObject -Property @{
    Name = $Name
  };

MyITGuy

@ECHO OFF
SET JRE_RUNNING=
SET PROBLEM=
SET INST_FILE=%~n1
SET LOG_DIR=%windir%\system32\LogFiles
SET CMD_OPTS= /s REBOOT=ReallySuppress /L*v "%LOG_DIR%\%INST_FILE%_inst.log"

ECHO.
ECHO Check for installer requirements...
ECHO.

MyITGuy

$PackageServers = Get-SMPSQLData -Instances "SQL0040" -Database "Symantec_CMDB_TNKNXSMP01" -CommandText 
"SELECT [FQDN] = [conn2].[FQDN], [Name] = UPPER([conn1].[Name]), [IP Address] = [conn1].[IP Address] FROM [vComputer] 
[conn1] LEFT JOIN [Inv_AeX_AC_Identification] [conn2] ON [conn1].[Guid] = [conn2].[_ResourceGuid] WHERE [conn1]. 
[Guid] IN (SELECT DISTINCT [PkgSvrId] FROM [SWDPackageServer]) ORDER BY [conn1].[Name]"

MyITGuy

#region Set-ProcMonAltitude
function Set-ProcMonAltitude {
    [CmdletBinding()]
    PARAM(
        [Parameter(Mandatory = $false, Position = 0)]
        [int32[]]
        $Version = @(23, 24)
        ,
        [Parameter(Mandatory = $false, Position = 1)]
        [int32[]]

MyITGuy

SELECT
  [conn2].[Name]
  , [conn1].[TotalCount]
  , [conn1].[LicenseInUseCount]
  , [PercentageUsed] = (
    CASE
      WHEN [conn1].[LicenseInUseCount] > 0 THEN ROUND(((CAST ([conn1].[LicenseInUseCount] AS FLOAT) / 100.0) / (CAST( [conn1].[TotalCount] AS FLOAT ) / 100.0)) * 100, 2)
      ELSE 0
    END
  )

MyITGuy

<!-- Example Deployment Rule Set that allow a desktop administrator to control end-user's execution of browser applets.
See http://docs.oracle.com/javase/7/docs/technotes/guides/jweb/security/deployment_rules.html -->
<ruleset version="1.0+">
	<rule>
		<id location="http://payroll.example.org" />
		<action permission="run" />
	</rule>
	<rule>
		<id location="http://knownvendor.example.com/program" />
		<!-- For example if an application is known not to work on Java 1.7 -->

MyITGuy

-- List Automation Policies
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT *
FROM [vItem]
WHERE [ClassGuid] = 'BEC44BD0-F31C-43C2-9391-52F176D67A04' -- Altiris.Automation.AutomationPolicies.AutomationPolicy
ORDER BY [Name]

MyITGuy

-- List Automation Policies Email Addresses
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT
	[Automation Policy] = [conn1].[Name]
	, [TO_EMAIL] = CAST([conn3].[State] AS XML).value('(/item/UniversalTaskManagementDataSourceAdapter/ActionParametersMap/SerializableDictionary/entry/value/ActionParameterMappingTuple[ActionParamName="TO_EMAIL"]/CustomValue/string)[1]', 'varchar(max)')
	, [CC_EMAIL] = CAST([conn3].[State] AS XML).value('(/item/UniversalTaskManagementDataSourceAdapter/ActionParametersMap/SerializableDictionary/entry/value/ActionParameterMappingTuple[ActionParamName="CC_EMAIL"]/CustomValue/string)[1]', 'varchar(max)')
FROM
	[vItem] [conn1]
	-- Connect to Altiris.Automation.AutomationPolicies.ActionDataSourceAdapters.UniversalTaskManagementDataSourceAdapter