Reporting to grab Asset data values I choose and Software Inventory

Are you looking for something like this:

Yes that is exactly what I'd like to see, but then be able to choose what columns/data, etc.

You might already be able to do that.  I created that table with the web based report writer.  Having the report only run against only nodes that have Office would require using the SWQL query.  It would like sort of like this:

SELECT  Nodes.DisplayName, Software.Name, Software.InstallDate, Software.Publisher, Software.Version

    FROM Orion.AssetInventory.Software

    INNER JOIN Orion.Nodes ON Software.NodeID=Nodes.NodeID

    WHERE Software.Publisher like 'Microsoft%'

You can add/remove other columns to this if you need.  All you would need to do is change the select portion of the query.  Try using that as a starting point.  You could also try the template that aLTeReGo made a few years back.  Here's that link Software Inventory by Node.  Hopefully that helps.

This is for Web Help Desk.  I don't have Orion.  I believe the web report writer is only something for Orion correct?

This is for Web Help Desk.  I don't have Orion.  I believe the web report writer is only something for Orion correct?

I am not sure about Web Help Desk.  Running the SQL query to make the report or you might try an API call, one of those would likely your best bet. Would you be able to provide the table structure?  I looked on the web, but I wasn't able to find one.