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

In my recent research with Barcode Solution, I came across the following Remote Control Software for Barcode Devices. This software was really handy in all aspects; I used it with the MC9090-G, MC70, and MC50 devices.

They also have different levels for Enterprise devices as well as a cheaper consumer product. You can also download the product and test it for 7 days. If you email and request a longer trial period they will send you a 30 day product key.

Enterprise Products:

  • MobiControl V5
  • Pocket Controller Enterprise V5.06

Consumer Products:

  • Pocket Controller Pro V6
robertser | 10 Sep 2008 | 6 comments

Need to get files other than the standard .exe files into your inventories. Perhaps the programs you need to inventory do not have .exe files such as ActiveX Controls.

These can easily be added in by using the Audit Plus Configuration Editor that is part of Inventory Solution. By default it is found in this folder on your Notification Server: Program Files\Altiris\Notification Server\NSCap\Bin\Win32\X86. Run AexAPedit.exe and click on the File Masks tab.

The instructions there show that you can only enter in file types such as *.DLL or *.OCX. You can also enter in full filenames. A good example is "flash*.ocx". This inventories the different Flash Player files that will let you know what versions of Flash Player you have installed.

We use this quite extensively and can then build Software Delivery jobs and other tasks...

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...
robertser | 09 Sep 2008 | 1 comment

It is nice to be able to see who the primary user is in a report. Since the Primary User table is based on a given month you have to add that as a parameter to every report you want to see Primary User on.

With this SQL view you can easily join it to your custom reports and always have the Primary User for the current month without having to create parameters.

Copy the below code into a new view in your Altiris database. Name it something easy like vw_PC_to_PrimaryUser.

SELECT DISTINCT _ResourceGuid AS 'Guid', Month, [User], Domain
FROM     dbo.Inv_AeX_AC_Primary_User
WHERE   (Month = DATENAME(Month, GETDATE())) AND ([User] <> '')
SELECT DISTINCT _ResourceGuid AS 'Guid', Month, [User], Domain
FROM     dbo.Inv_AeX_AC_Primary_User AS Inv_AeX_AC_Primary_User_2
WHERE   (Month = DATENAME(Month, DATEADD(Month, -...
BRING | 05 Aug 2008 | 1 comment

One of the toughest parts of Barcode is understanding how licenses can be freed up for scanners no longer in use.

In latest releases, a concurrency model is used, where the concurrent number of scanners registered is what matters, not specific scanners. The user interface now also has functions to recycle or reclaim licenses from unused scanning devices.

However, in Version 6.6, licenses were held by a particular scanner until 2 things happened:

  1. That particular scanner did not report any scanning updates for 30 days.
  2. A weekly scheduled task runs on the Notification Server.

So, if you have 6.6 or older, and need more licenses, you can purchase more, or retire and recycle the older ones after 30 days of inactivity.

SandyF | 22 Jul 2008 | 0 comments

Want a report of the assets on a purchase order along with the owner and location? Give this a try.

-- In owner's resource association, parentresourceguid is asset guid and childresourceguid is user guid   
select distinct as 'PO Number', as 'Asset',  
     va.[Serial Number],  
     va.[Asset Type],  
     [Unit Cost] as 'Unit Cost',  
     [Quantity] as 'Quantity',  
     O.ParentResourceGuid as _ResourceGuid,  
     IAL.Name as 'Asset Location', 
     IU.Name as 'Owner', 
     IUL.Name as 'Owner''s Location', 
     va.Status, va.Manufacturer, va.Model, va.[System Number], va.Barcode, va.[Last Barcode Scan], va.[Asset Tag]	 
--     va.*  
from inv_parent_lines rec  
join item i   
 on rec.[_resourceguid] = i.[guid] --receiving slip  
join Inv_Line_Items li  
 on rec.[parent line item id]=li.[line item id] --PO  
join item j   
 on li.[_resourceguid]=j.[guid]   
join vReceivingslipassoresource rs  
 on i.guid=rs.parentresourceguid  
nravenscroft | 22 Jul 2008 | 0 comments

Last time we covered adding a collection picker to your reports. In case you missed it you can find it here. I know after reading the prior tip you were excited beyond belief, and happily adding collection pickers to all your reports.

That is until you realize that you have to select a collection each and every time you want to run the report, and most of the time you end up selecting the same collection. Fear not, because today I'll show you how to set the default collection.

First off we need to pick a collection. Let's go with the All Computers collection. We'll need to browse to the collection in the NS console right-click it and choose properties.

nravenscroft | 18 Jul 2008 | 1 comment

The Item picker is a great tool for extending the functionality of reports. More specifically the collection picker allows you to dynamically manage the scope of your reports.

In this article we'll go over how to create and use a collection picker.

Go ahead and click finish and then open the edit windows for the report.

Once in the Edit window we'll need to create a couple parameters, so click the New Parameter button and create a basic string parameter called AppName be sure to click the box for to Prompt User, type a friendly name and set the default...

SandyF | 16 Jul 2008 | 0 comments

The following query lets you see all assets for a given PO number. Notice the WHERE clause at the end where you can substitute a parameter to allow you to specify a PO Number at runtime.

/*List PO, Receiving Slip Number and the Assets that where created when     */
/* using the receiving process. Software items are not reported in this report. */

select as 'PO Number', j.Description, as 'Receiving Slip', as 'Asset', va.[Serial Number], va.[Asset Type], va.*
/* For more details on the POs and receiving slips, remove the two dashes at the beginning of the next line */
 --, rec.*, li.*, i.*, k.*, j.* 
from inv_parent_lines rec
join item i on rec.[_resourceguid] = i.[guid]-- Receiving slip
join Inv_Line_Items li
 on rec.[parent line item id]=li.[line item id] -- PO
join item j on li.[_resourceguid] = j.guid
join vReceivingSlipAssoResource rs
 on i.guid = rs.parentresourceguid
join item k on k.guid = rs.childresourceguid -- Asset
join vAsset va on rs...
SandyF | 15 Jul 2008 | 1 comment

If you would like to track other types of software licenses other than "Concurrent" or "Per Installed Node", you can add your own. For example "Per Processor" or "Enterprise".

  1. Go to Resources Settings under Configuration.
  2. Drill-down on Data Classes > Contract Data Classes > Software License Data Classes > Software License Detail.
  3. Click the pencil icon next to License Type.