Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog
Showing posts tagged with Symantec Management Platform (Notification Server)
Showing posts in English
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>

SK | 20 Jan 2014 | 11 comments

HF3 for ITMS 7.5 is now available via SIM.  Please review the attached screenshot for the seven products that it can update.

SK | 17 Jan 2014 | 0 comments

I have just updated my article by adding a comment that includes the SQL behind the new view that ITMS 7.5 adds to "Manage > Software".

https://www-secure.symantec.com/connect/articles/s...

andykn101 | 15 Jan 2014 | 0 comments

There is a useful SQL query in TECH183347 to measure queue processing but it doesn't contain descriptions for the Queue numbers, I've added a few CASE statements to do this:

SELECT Queueid As [Queue ID],
 [Queue]=CASE Queueid
 WHEN 0 Then 'Priority'
 WHEN 1 Then 'Fast'
 WHEN 2 Then 'Normal'
 WHEN 3 Then 'Slow' 
 WHEN 4 Then 'Large'
 END, COUNT(Id) AS [THREADS IN USE] 

FROM EventQueueEntry where ProcessingState = 2 
GROUP BY ProcessingState, QueueId order by queueid, ProcessingState
The descriptions are taken from DOC5480: http://www.symantec.com/docs/DOC5480
 
TECH183347: http://www.symantec.com/docs/TECH183347
SK | 31 Dec 2013 | 1 comment

After a clean install of ITMS 7.1.2 MP1.1 v7RU, it was found that it was not possible to create a new CMDB rule as its first dropdown list failed to open.

To workaround this issue, you need to clone a sample CMDB rule and then modify it to suit your needs.

SK | 28 Dec 2013 | 0 comments

Here is a handy SQL query that will allow you to search your database tables for a particular word or words (tested against SQL 2008 R2):

**********************************

CREATE TABLE myTable99 (TABLE_NAME sysname, COLUMN_NAME sysname, Occurs int)
GO

SET NOCOUNT ON

DECLARE @SQL varchar(8000), @TABLE_NAME sysname, @COLUMN_NAME sysname, @Sargable varchar(80), @Count int

SELECT @Sargable = 'enter word or words here'

DECLARE insaneCursor CURSOR FOR
    SELECT c.TABLE_NAME, c.COLUMN_NAME
      FROM INFORMATION_SCHEMA.Columns c INNER JOIN INFORMATION_SCHEMA.Tables t
        ON t.TABLE_SCHEMA = c.TABLE_SCHEMA AND t.TABLE_NAME = c.TABLE_NAME
     WHERE c.DATA_TYPE IN ('char','nchar','varchar','nvarchar','text','ntext')
       AND t.TABLE_TYPE = 'BASE TABLE'

OPEN insaneCursor
 ...