Video Screencast Help
Endpoint Management Community Blog
Showing posts tagged with Symantec Management Platform (Notification Server)
Showing posts in English
SK | 20 Mar 2014 | 0 comments

Hello all,

Today I ran into the above mentioned problem whilst trying to perform a clean install of ITMS 7.5, so I thought I would share what worked and what didn't.

Windows 2008 SP1 R2 with SQL 2012 SP1.

SQL was initially configured for Windows Authentication.  When SIM failed, I manually created the database to no avail.

I then changed to mixed authentication and changed the SA account (as I obviously didn't know what the original one was) via the UI.  Unfortuantely, the SA account had the same problem.

 

What worked was running the following query:

USE master
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewSAPassword', CHECK_POLICY = OFF
GO
ALTER LOGIN [sa] ENABLE
GO

 

This allowed SIM to create the database and begin the installation phase.  Once ITMS 7.5 was installed, and the 9 hotfixes (required a rebot beforehand), I opened the Database Settings page and...

artrathke | 11 Mar 2014 | 1 comment

This position is a 6 month contract-to-hire with a company in Detroit.

Altiris Administrator

Altiris Administrator/Developer responsible for the administration and maintenance of the Altiris/Symantec server environment including installations, configurations, and customizations and reporting and the Development and support of Applications and Altiris Workflows.     

 

Job Description

·       Provide day to day management and support for the Altiris Service Desk, SMP and Workflow applications.

·       Respond quickly and effectively to reported Incidents and Troubleshoots problems and provides technical support and solutions. Create automated and  Ad-hoc report as necessary

·       Write, Test, deploy and support custom code...

SK | 06 Mar 2014 | 2 comments

The following query will list the contents of all item folders found within the console:

SELECT vi1.Name As Folder,vi2.Name AS Item
FROM vItem vi1
JOIN vItemFolder vif ON vif.ParentFolderGuid = vi1.[Guid]
JOIN vItem vi2 ON vi2.[Guid] = vif.ItemGuid
ORDER BY Folder,Item ASC
--WHERE vif.ParentFolderGuid = 'folderguid'
--WHERE vi1.Name = 'foldername'

If you wish to use one of the WHERE clauses, then make sure you remark (--) the ORDER BY line.

SK | 04 Mar 2014 | 1 comment

Release Notes and the actual RU can be obtained from HOWTO81832.

SK | 19 Feb 2014 | 1 comment

"Symantec™ IT Management Suite 7.5 HF4 powered by Altiris™ technology Release Notes" (http://www.symantec.com/docs/DOC7126)

SK | 12 Feb 2014 | 1 comment

If you have chosen to create your sites and subnets manually instead of importing them from AD, what is the easiest way to create filters that contain the computers associated with those sites?

The following query is one way of achieving this goal (another method would be to target the actual subnets contained in each site):

  SELECT ip._ResourceGuid
  FROM Inv_AeX_AC_TCPIP ip
  JOIN vSubnet sub ON sub.Subnet = ip.Subnet
  JOIN vSiteSubnetMap map ON map.SubnetGuid = sub.[Guid]
  JOIN vSite s ON s.[Guid] = map._ResourceGuid
  WHERE s.Name = 'name of site'

SK | 08 Feb 2014 | 1 comment

The following query maps item names to the three different guids found within the ResourceAssociation table, allowing you to understand its contents better:

SELECT
vi1.[Guid] AS ResourceAssociatiopnTypeGuid,vi1.Name AS ResourceAssociatiopnType,
vi2.[Guid] AS ParentResourceGuid,vi2.Name AS ParentResource,
vi3.[Guid] AS ChildResourceGuid,vi3.Name AS ChildResource
FROM vItem vi1
JOIN ResourceAssociation ra ON ra.ResourceAssociationTypeGuid = vi1.[Guid]
JOIN vItem vi2 ON vi2.[Guid] = ra.ParentResourceGuid
JOIN vItem vi3 ON vi3.[Guid] = ra.ChildResourceGuid
ORDER BY vi1.Name ASC

SK | 31 Jan 2014 | 5 comments

Today marks the last day that my community status will display Symantec Employee.

I will endeavour to maintain a community presence; however, I do not know how frequent this will be.

SK | 28 Jan 2014 | 5 comments

If you are testing Application Metering either in the lab or during a POC, you may wish to have the Application Metering Agent (AMAgent) send its data in a timely fashion, as its UI only offers either Daily or Weekly.

 

 

The following queries will allow you to do just this as well as to revert back to the original setting afterward for supportability:

 

--/ Obtain existing value (default = 86400)

SELECT State FROM Item WHERE [Guid] = '97D80113-8FE1-4ABD-AB08-EC7C8DDBDEF5'

 

--/ Change default using value in seconds (this example is for 5 minutes)

UPDATE Item SET State = '<item><Application type="inventory" interval="360" /></item>' WHERE Guid = '97D80113-8FE1-4ABD-AB08-EC7C8DDBDEF5'

 

--/ Rollback

UPDATE Item SET State = '<item><Application type="inventory" interval="86400" /></item>' WHERE Guid = '97D80113-8FE1-4ABD-AB08-EC7C8DDBDEF5'...

SK | 21 Jan 2014 | 0 comments

One unfortunate difference between SMP 7.1 and 7.5 is that in 7.1, when you run a report, the SMP records a number of "Altiris.Reporting....." entries in its logs; two of which were high useful:

 

Source: Altiris.Reporting.DataSource.ResourceDataSource.Run
Description: ResourceDataSource returned N rows in 'Table' table

N equates to the number of rows that you report displayed, making it easy to locate the write log records, because immediately below this line will be the actual reports SQL that was used:

Source: Altiris.Reporting.DataSource.ResourceDataSource.Run
Description: ResourceDataSource is running query:

<Reports SQL starts here>