Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog
Showing posts tagged with Client Management Suite
Showing posts in English
Jan Trnka | 15 Dec 2014 | 0 comments

For maintenance purpose you may like this report:


You can easily create your new SQL Report with Role Name, Created/Modified Date and Description:

Here is the query for you:

SELECT TOP 1000 [Name]
  FROM [Symantec_CMDB].[dbo].[SecurityRole]

You can use it along with Report of Security Accounts

Marcello D'Angelone | 27 Nov 2014 | 0 comments

There are three ways to find this information:

1) From the SMP Console you can simply add the machine's resource GUID value at the end of the link below:
2) From the Console go to Manage > Computers search for the computer Name then Right-click, select
Resource Manager for that particular system, and go to Summaries > Filter Summary.
3) From SQL Server Management Studio
you can look at the CollectionMembership and connect this with item and/or vcomputer table, for example with the following query:
SELECT v.Name AS 'Computer Name', i.Name AS 'Filter Name', p.Name AS 'Solution', i.CreatedDate AS 'CreatedDate', i.ModifiedDate AS '...
Network23 | 20 Nov 2014 | 0 comments

Hi Enpoint Management Community,

ITMS 7.5 SP1 HF4 is available via SIM!

Release Notes can be found here

ianatkin | 29 Oct 2014 | 0 comments

Two unrelated but noteworthy items I came across this week. The game ELITE and a article on Windows 10.


If you don't know the about the game Elite, it was something rather special when I was growing up.  


Thanks to a £1.5m KickStarter fund, it's now being remade by one of the original creators (David Braben)  to the excitement of many beer-swigging-40-something-year-olds at It's looking like it's going to be something rather special.  
And to top it all, there is a launch party in Cambridge (UK) at a war museum (how cool is that??!?) this month. My name is in a hat for attending. Exciting stuff...

hugo_parra | 29 Sep 2014 | 23 comments

Announcing the availability of ITMS 7.5 SP1 HF3.

This release is available through SIM and contains a number of fixes for the following components:

  • Symantec Management Platform
  • Inventory Solution
  • Deployment Solution
  • Software Management Solution



ianatkin | 19 Sep 2014 | 2 comments

I've been fiddling over the last wee while with an idea for DS6.9 (see my previous blog entry). I've been thinking about how to introduce a working method for implementing global variables.

You see, my complex jobs often have user-editable parameters scattered throughout them. Scattering variables throughout a jobs task is really messy (and makes them harder to maintain). So, I thought about how we could just have one place where we put these variables in a job.

A special task in DS6.9 would have been nice. Something like this,


But this doesn't exist... so I've implemented something less elegant, and a full article on that will be posted shortly. If you think this would be advantage you you (in both DS6.9 and DS7) please comment.

If you know people who *would* like...

ianatkin | 19 Sep 2014 | 0 comments

Today I was reviewing one of my T-SQL User Defined Functions (UDFs) and got distracted on the SQL Blog site,

An article by Hugo Kornelis  had caught my attention, T-SQL User-Defined Functions: the good, the bad, and the ugly

This caught my eye as as I often create T-SQL User Defined Functions (UDFs) in order to simplify the look of my T-SQL code and make pieces of it easier to maintain in the long term. Hugo however demonstrates quite clearly how implementing scalar UDFs can be really, really bad. The problem is their performance can't be optimised by the SQL engine, so each call to the UDF comes with the same cost. He then demonstrates massive performance gains by putting even simple UDF code in-line in your T-SQL.

His bad news doesn't end there -the execution plans also lie about the cost, hiding...

ianatkin | 05 Sep 2014 | 2 comments

I often find myself peeking into Altiris databases with the goal of finding a particular piece of information. The only problem is, I rarely know what table it's stored in.

There are three options at this point,

  1. Stare vacantly at the database, scanning through every table name waiting for an internal bell to tinkle
  2. Google till you dribble
  3. Run a SQL Query to find your table

In case you are an option (3) type of admin, this is the query to use,

FROM    sys.tables

FROM    sys.views
WHERE   Name like '%BIOS%'

Where here, in this instance, I'm looking for tables and views whose name includes the string "BIOS". This is a truely invaluable little query, and very helpful when trying to update reports across database versions. It's even quite handy if you simply are feeling a bit nosey.

ohzone - CherylPeterson | 04 Sep 2014

You may notice a few changes in the Endpoint Management Community product names. We've updated the product names to align more closely with what appears on the site as well as the terms that Symantec Support use. Product descriptions have also been updated. These changes offer a better description of what the product does and in some cases indicates a product's End of Life (EOL) status.

All forums and threads are still available and searchable. We hope you find these changes helpful.