Video Screencast Help
Endpoint Management Community Blog
Showing posts tagged with Altiris IT Asset Management
Showing posts in English
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.


SandyF | 14 Jul 2008 | 0 comments

Hotfix 6.7.8 has separated the install of the Barcode Manager on the workstation and the Barcode software on the handheld. Active Sync is only required if using a separate handheld scanner.

The hotfix also changes the licensing. The console pages now do true concurrent licensing with a Barcode Solution license freeing up within 5 minutes of the console page closing.

See KB 41762 for more information.

SandyF | 11 Jul 2008 | 3 comments

If you have ever wanted a single report with the Purchase Order number, the Purchase Request reference, Invoice Reference and Receiving Slip Reference all together, see if this will work for you.

  1. Clone the report "All Purchase Orders" found in Asset & Inventory > Receiving > Purchase Orders
  2. Edit the report and replace the SQL with the following
    SELECT I.Guid AS _ResourceGuid, 
    	IPOD.[Order Number], 
    	dbo.fnLocalizeStringByGuid('', raSup.ChildResourceGuid, '%_culture%') as [Supplier], 
    	SUM(ILIP.Quantity) as [Number of Items], 
    	isnull(Received.[Count],0) as [Number of Received Items], 
    	sum(isnull(ILIP.Quantity,0) * (isnull(ILIP.[Unit Cost],0) + isnull(ILIP.[Tax Amount],0)) ) as [Total Cost], 
    	isnull(reqTab.Name,'') as Requestor, 
    	dbo.fnGetLinkedReceivingItemAsString(I.Guid,'06c97c09-f96d-4260-a119-061396a67eb9') as [PR Reference], 
    	dbo.fnGetLinkedReceivingItemAsString(I.Guid,'22538eed-17fe-42cd-889d-949a15e3cf03') as [Invoice...