Video Screencast Help

Endpoint Management Community Blog

Showing posts tagged with Altiris IT Asset Management
Showing posts in English
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...

SK | 10 Dec 2013 | 1 comment

The following query has the ability to list all Software Releases and their associated rules or just the rules associated with a specifc Software Release:

SELECT rsr.Name AS [Software Release],rir.Name AS [Rule],rir.[Description] AS [Rule Description]
FROM RM_ResourceSoftware_Release rsr
JOIN ResourceAssociation ra ON ra.ParentResourceGuid = rsr.[Guid]
JOIN RM_ResourceInventory_Rule rir ON rir.[Guid] = ra.ChildResourceGuid
--WHERE rsr.Name = 'specific software release'
ORDER BY rsr.Name ASC

As Applicability and Detection rules are both classed as inventory rules, they do not have their own resource type or class; however, it does appear that detection rule names begin with "Detection Rule for", which should allow you to distinguish between the two.

Chad Dupin | 24 Oct 2013 | 0 comments

 ITS_Altiris_Roadshow_Header.png

We’re loading up the RV and hitting the road with Symantec to talk about Altiris 7.5. And We’re Coming To A City Near You.

Okay, we’re not actually loading up an RV, but it sure would be fun if we could!  We’re so excited to be part of this big release. The Altiris experts from ITS will review the 7 and a half reasons everyone should consider upgrading to the Altiris 7.5 platform. We’ll provide an overview of the features and capabilities that are new to the 7.5 platform, as well as how those will enable better management of your IT environment. You’re probably asking yourself, what are we actually going to talk about? Here’s what we’ll be covering:

  • Cloud Enabled Management
  • Deployment Solution
  • Macintosh Management
  • Performance
  • ...
Ludovic Ferre | 07 Oct 2013 | 3 comments

The symantec.pl.xml update for 7.5 has hit SolutionSam.com, so 7.5 is now GA.

Here are some information from the product listing:

file md5  = b8675ec97437e633fbcad1c112a6a557
file size = 15 361 694 bytes
timestamp = 2013-10-03 10:59

And here its the full file list (and handfull as you could guess :D):

Modified:
/solutions/7_5/eipower/7_2_rtm/ei_powersaversolution_7_2_perth.msi
 
Added:
/solutions/7_1/ita/ita_doc/altiris_itanalyticsdocumentation_x64.msi
/solutions/7_5/itms/7_5_rtm/altiris_activitycenter_7_5_x64.msi
/solutions/7_5/itms/7_5_rtm/altiris_activitycenterlanguages_7_5_x64.msi
/solutions/7_5/itms/7_5_rtm/altiris_agentlessinventoryupgrade_7_5_x64.msi
/solutions/7_5/itms/7_5_rtm/altiris_agentlessinventoryupgrade_7_5_x86.msi
/solutions/7_5/itms/7_5_rtm/altiris_assetmanagementcombine_7_5_x64.msi
/solutions/7_5/itms/7_5_rtm/altiris_assetupgrade_7_5_x64.msi
/solutions/7_5/itms/7_5_rtm/...
michael cole | 31 Jul 2013 | 0 comments

I came across a stored procedure that is quite popular for troubleshooting SQL especially blocking, it's not new but deserves a repost. I tried it against sp_who and sp_who2. It seems that this SP gives a more instant snapshot in better detail. Probably it's best feature is a clickable link to the transact that is running. I could still see block chains better with sp_who2, as you could see the trail of SPID's better. There is a SQL query for finding the lead blocker at http://sqlserverplanet.com/troubleshooting/blocking-processes-lead-blocker

For those that are interested in what the differences are between sp_who and sp_who2, the screen snip below shows the column differences, the hidden difference is that sp_who is documented and thus supported, otherwise they are very similar. SP_WhoIsActive complements them.

Disclaimer

...
ohzone - CherylPeterson | 30 Jul 2013 | 0 comments

We love our Connect community members and once again we're celebrating SysAdmin day. Check out this blog to find out how we are sharing the love with you!

Happy International Sysadmin Day!

Tell us something crazy that's happened in your world and we might make it worth your time!

ohzone - CherylPeterson | 23 Apr 2013 | 0 comments

Travelport needed to improve visibility into its environment. Prior to implementing Altiris, IT could see how many endpoints were on the network, but had now way to really manage each individual system from a single location. To address this problem, Travelport implemented Altiris IT Management Suite (ITMS), which allows Travelport to have a single view into its environment and makes it possible to manage each individual system centrally. To learn more about how Travelport is using Altiris ITMS, including Altiris Client Management Suite, Server Management Suite, Asset Management Suite, and Symantec Workflow check out this video: http://bit.ly/YRctqu   

ohzone - CherylPeterson | 15 Apr 2013 | 0 comments
As of April 2014, Microsoft will no longer offer service to Windows XP. With the deadline approaching, many organizations are either preparing or putting off their respective migration to either Windows 7 or Windows 8. With a well-crafted Windows migration strategy in place, companies can improve user productivity, enhance security, and avoid high installation costs. Symantec suggests a four-pronged approach to help ease the burdens migration can cause. These suggestions are: 
  1. Assess
  2. Prepare and plan
  3. Ready to migrate
  4. Post-migration management
Coupled with Symantec’s superior migration solutions that both simplify and secure the overall process, these tips will help your organization successfully navigate the complex process quickly and efficiently. Stop worrying about tomorrow and let Symantec help you today! To learn the best tips for successful migration, check out this article:...
ohzone - CherylPeterson | 03 Apr 2013 | 0 comments

Getting the right endpoint management solution in place is analogous to architecting and erecting a building. So where do you start?

Read this interesting article by Patrick Spencer in the latest issue of CIODigest http://bit.ly/10xDpJq

Screen Shot 2013-04-03 at 2.41.52 PM.png

InfaSean | 26 Mar 2013 | 0 comments

Hello,

 

We have an immediate opening for an Altiris admin in Redwood City. CA.   If you would like additional details, please contact me directly @ scurran@informatica.com

 

Thank you,

 

Sean