Video Screencast Help

Endpoint Management Community Blog

Showing posts tagged with Altiris IT Asset Management
Showing posts in English
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 j.name as 'PO Number', j.Description, i.name as 'Receiving Slip', 
    k.name 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('item.name', 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...
SandyF | 21 May 2008 | 1 comment

Have you ever wanted to generate a report of purchase orders and the serial numbers of the assets created by those purchase orders? Here you go:

/*List PO, Receiving Slip Number and the Assets that 
were created when receiving process is used.  Software 
items are not reported. */

select j.name as 'PO', j.Description, 
       i.name as 'Receiving Slip', 
       k.name as 'Asset', va.[Serial Number], 
       va.[Asset Type], va.*

/* Remove the two dashes at the beginning of the next line of code to get more detail on the PO and Receiving slip. */

 --, rec.*, li.*, i.*, k.*, j.* -- more detail
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.ChildResourceGuid =...
savnhga | 08 May 2008 | 6 comments

If you have problems where your MC50 doesn't scan the correct barcode all the time and you have to delete the entry and rescan it, the "Imager Pick List" option will help!

The "Imager Pick List" will give a user the ability to choose which barcode they need scanned. This usually happens when multiple barcodes are beside each other.

The MC70, MC9090-G, and some newer MC50s have this option already, no need to upgrade the OS.

On the MC50 you will need to either update the OS or update the device to have the "Imager Pick List" option. Instructions for how to do the updates are in the link.

"Device Configuration Package v1.4 and OS Update for the MC50":
...

vortex0007 | 22 Apr 2008 | 6 comments

I'm always surprised to find how few customers take advantage of Altiris Inventory Solution's ability to inventory an application's installed serial number. This information can be invaluable when trying to tie copies of applications installed in your environment back to software license agreements.

Each time Altiris Inventory Solution scans are run, the serial numbers for installed applications are captured and stored in the Inv_AeX_OS_Add_Remove_Programs table.

It is impossible for us to list every single application that will report back a serial number properly, but testing in large environments has revealed at least 500 business applications that return this information properly, including most of the business applications from Microsoft, Adobe.

The following SQL query can be run against the Altiris database to find out...

SandyF | 28 Mar 2008 | 1 comment

With the release of Asset Management 6.5 the whole process of Receiving and Stock Rooms have been added. Here is a summary of how the stock room is used.

Stock rooms are used to house and monitor consumable catalog items. Consumable items are less important assets that are not tracked as individual resources but by quantity in the Stock Room resource type. Stock rooms are linked to a manager who is the recipient of stock allocation requests and order notifications. Stock room order items can be linked to an owner. For consumables this must be a cost center/department (as the cost is attributed to the cost items dataclass), which ensures that accounting details are recorded. Stock rooms are unique based on location.

In the Stock Order Details, the Order Level field for each row, means that when the number of a particular item in the stock room goes down to the specified order level, the stock room manager will be notified, and a purchase order will be...

neil_rogers | 31 Jan 2008 | 4 comments

I recently received request for a report that would show which of our computers are covered by a warranty. I looked around and didn't see a report off hand (that was not tied to the expiration of the warranty) but I did see a lot of similar reports for expiring leases.

Hopefully my solution to this reporting problem will come in handy for someone else.

My Solution

Change the attached txt file to xml to import into NS.

This report first shows all warranties. Choose a warranty and right click for a drill down to show the active computers that are covered by the warranty.

While I just list the warranty and the computer, to see all the associated fields available, add a * to see all the rows of data that are available.

Here are the two sql queries:

level 0:
Select * from vWarranty

level 1...
Global_Altiris | 18 Jan 2008 | 2 comments

Check out this best practice document from the Business Software Alliance, A.K.A. The people who bust companies for software piracy. It contains some easy and obvious best practices for Software Management.

"Of the $13 million that the Business Software Alliance (BSA) reaped in software violation settlements with North American companies last year, almost 90 percent came from small-medium businesses" -Associated Press 11/26/2007

http://www.bsa.org

Altiris Solutions & Reports backed up by strong corporate policies can help keep you off of their radar!