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
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...

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  
     j.name as 'PO Number',  
     k.name 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  
join...
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 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 | 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...
MBHarmon | 27 Jun 2008 | 0 comments

In some environments, or for some ticket types, there always needs to be an Asset. After all it doesn't make much sense to have an install software request without a computer seleted. For those options you can create a validation rule that will require this option.

If creating your validation rule for something such as as "Request" Type just enter it with the following parameters:

Name: Asset must be selected

Comment: Requires workers to enter select an Asset when none has been selected.

Display this message: Please select a valid Asset. The Asset NONE is not valid for requests.

When: Every time incident is saved

When ALL of these are TRUE
 "Type" is not equal to "Request"
 "managed_object_id" is the same as "1"

To enter the last line of that...

CondorMan | 05 Jun 2008 | 2 comments

I just learned that you can enable MSI logging so that if your installer fails with an error you can see where the MSI failed.

To enable MSI loggging:

  1. Open Regedit.
  2. Go to HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Windows\Installer.
  3. Create a new Reg_SZ value named "Logging" with the value "voicewarmup".

While "voicewarmup" is easy to remember, it actually signifies all of the different options that you want to enable.

Here is the complete list of options:

v Verbose output
o Out-of-disk-space messages
i Status messages
c Initial UI parameters
e All error messages
w Non-fatal warnings
a Start up of actions
r Action-specific records...
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 =...
TilakGovind | 14 May 2008 | 2 comments

If you have to install applications to any other Physical Drive (not network drive) you can do so in the following way.

default INSTALLDIR : C:\Program Files\Dir1

Change to D:\Program Files\Dir1

  1. In the MSI Script create a custom action In "User Interface" just after "Cost Finalize"

    "Set Directory" give it a Name, choose the directory by browsing to ProgramFilesFolder\Dir1 and in the third Blank Space enter "D:\Program Files\Dir1"

  2. Create the same Custom action in "Execute Immediate" just after "Cost Finalize" also

    This installation works fine as long as D: is a valid Drive, it does not work on drives that were created using "Subst.exe" Command.