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

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:

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

You can find whether a software package is installed on computers on you network by querying the [Inv_AeX_OS_Add_Remove_Programs] table.

Here's how to find the machine name by joining the [Inv_AeX_AC_Identification] table.

QUERY:

SELECT DISTINCT(ACI.[Name]) AS 'Machine Name', ACI.[Domain] AS 'Domain', ARP.[Name] AS 'Application Name'
FROM  [Inv_AeX_AC_Identification] ACI 
INNER JOIN [Inv_AeX_OS_Add_Remove_Programs] ARP 
ON ACI.[_ResourceGuid] = ARP.[_ResourceGuid] 
WHERE ARP.[Name] LIKE '%Application Name%' 
ORDER BY ACI.[Name]