Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog
Showing posts tagged with Reporting
Showing posts in English
BRING | 17 Sep 2008 | 0 comments

Why do I see the same installer listed 3 times when I created the Software Update Tasks for MS08-053? See the graphic below.

They are not actually the same. In creating the task, unfortunately Microsoft did not label the tasks differently for each operating system as they have with other bulletins. You can confirm this by selecting the installer under the "Update Name" column on the screen. It will show you a different guid for each one, and the description listed is unique.

robertser | 10 Sep 2008 | 1 comment

Great view to have in your Asset database for reporting the locations your PCs are at. With this view you can easily add a Location column with address to any report you have.

Copy the below code into you Altiris database and save it as a view. I would recommend naming it something easy like vwCSTM_PC_to_Location.

SELECT DISTINCT vc.Guid, vc.Name, vl.Name AS Location, vl.Address, vl.City, vl.State, vl.Zip, vl.Country, vsi.Name AS SiteCode
FROM     dbo.vComputer AS vc INNER JOIN
           dbo.ResourceAssociation AS vcra ON vcra.ParentResourceGuid = vc.Guid INNER JOIN
           dbo.vLocation AS vl ON vcra.ChildResourceGuid = vl._ResourceGuid INNER JOIN
           dbo.ResourceAssociation AS sura ON sura.ParentResourceGuid = vl._ResourceGuid INNER JOIN
           dbo.vSubnet AS vsu ON vsu.Guid = sura.ChildResourceGuid INNER JOIN...
MFINN | 04 Sep 2008 | 0 comments

One of the problems with the canned compliance reports is the lack of easily isolated Service Pack information, so I created a report that allows you to select Windows 2000, XP, or Vista and then filter out the most recent SP for that OS.

  1. Create a new report
  2. Give your report a meaningful name
  3. Enter SQL directly
  4. Copy and paste this SQL into the text box
  5. Click finish (testing won't work here, because we need to create a few parameters first)

*Continued below*


SELECT T0.[Name] AS 'Name', 
T0.[Domain] AS 'Domain', 
T0.[Last Logon User] AS 'Last Logon User', 
T1.[OS Name] AS 'OS Name', 
T1.[Service Pack] AS 'Service Pack' 

FROM [Inv_AeX_OS_Operating_System] T1 
RIGHT OUTER JOIN [Inv_AeX_AC_Identification] T0 
ON T1.[_ResourceGuid] = T0.[_ResourceGuid] 

WHERE T1.[OS Name] LIKE %...
Tony 1776 | 02 Sep 2008 | 10 comments

I got some of the code and the idea from dkerr and his Daily Ticket "Summary" E-mail, but I felt like more could be done with it and so I spent quite some time customizing it more.

Here is what the emails look like.

I was pretty excited when I found out that HTML can be entered into the email notification action. It just makes the email look quite a bit nicer, and I believe it should be viewable on a handheld device.

Following is the SQL query that goes in a notification policy:

...
MFINN | 27 Aug 2008 | 2 comments

Here's some SQL that'll query computers with MS Office 2003 without the Office 2007 compatibility pack. Just go to reports, create a new one, and select 'Enter SQL Directly', then copy and paste the sql into there.

SELECT T0.[Domain] AS 'Domain', T0.[Name] AS 'Name',
T0.[OS Name] AS 'OS Name', T1.[Name] AS 'Name' FROM 
[Inv_AeX_AC_Identification] T0 INNER JOIN 
[Inv_AeX_OS_Add_Remove_Programs] T1 ON 
T0.[_ResourceGuid] = T1.[_ResourceGuid] WHERE T1.[Name] 
LIKE 'Microsoft Office%' AND T1.[Name] LIKE '%Edition 
2003%' AND T0.[Name] NOT IN (SELECT T0.[Name] AS 'Name'
FROM [Inv_AeX_AC_Identification] T0 INNER JOIN 
[Inv_AeX_OS_Add_Remove_Programs] T1 ON 
T0.[_ResourceGuid] = T1.[_ResourceGuid] WHERE T1.[Name] 
LIKE 'Compatibility Pack for the 2007 Office system')

R-Vijay | 26 Aug 2008 | 0 comments

Have you ever thought about creating installer packages in Visual Studio?

Do visit this below link to have more insights on that. http://www.aspfree.com/c/a/VB.NET/Building-an-MSI-...

Topics which are covered in this link are,

  1. Building an MSI File: Visual Studio and Orca
  2. Building a Package
  3. A First Look at Shortcuts
  4. More About Properties
  5. GUIDs: Product, Upgrade, and Package Codes
  6. Into the Package with Programming
piyushnasa | 21 Aug 2008 | 10 comments

There are many installshield applications (MSI)/ Other Vendor MSI which come wrapped in setup.exe. The packagers can extract the MSI easily, but while installing the MSI, sometimes an error comes which says that the MSI can be installed only through setup.exe.

This can be solved by two ways:

  1. For Installshield applications, Set the Property ISSETUPDRIVEN=1, this will remove the error and you can install your MSI.
  2. If the above does not work and also for non Installshield packages, if you still get the error, then you can create a verbose log file and search for "Return Value 3". This will take you to the Custom Action which has caused the error. You can disable this CA and then try installing the application. This works most of the time. However there are some applications in which the same CA is doing more than one work....
MtBiker | 18 Aug 2008 | 5 comments

Application installation can become tricky at times. We have noticed problems with installing software and our Spy Sweeper blocking the installation. We then had a need to determine if the Spy Sweeper is installed and do some action if it is.

Thus I created a little script that will go out and check to see if a particular application is installed on a computer. First I will show the full VBS script, then go over some modifications you might have to make.

'This script outputs to a .tsv file a list of applications installed on the computer
'Output file is software.tsv
'Usage: cscript applications.vbs

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTextFile = objFSO.CreateTextFile("C:\WINDOWS\system32\temp\software.tsv", True)

strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
  & "{...
dpeluso | 04 Aug 2008 | 1 comment

I may be crazy but I could not find a nice easy way of reporting on the success of a software delivery task other than the 'status' tab (Which I can't copy to Excel).

So when I came across KB Article: How do I make a report that will give me the same info as the Status tab? https://kb.altiris.com/article.asp?article=3709&p=1

I was very happy however there are 2 issues:

  1. I need to specify the GUID.
  2. I need cannot limit based on success or failed.

So attached is my report that solves these issue, please rename from .txt to .xml.

By the way there are no warranties etc. my environment is NS v6.0.6074

...
License:
R-Vijay | 25 Jul 2008 | 3 comments

This very good article will help you understand Windows Vista better. There is a lot more to talk about. Once you go through that article, I believe your complaints would be reduced for sure!

You can obtain the article from http://www.microsoft.com/downloads/details.aspx?Fa...