Allow me to preface this question by first stating that I'm a relatively new user. I believe I have the concept of License Tracking and compliance down except I've run into a snag.

Our organization is a Microsoft Certified Partner and as you may know, part of that agreement allows you to install Microsoft products for testing, development and evaluation purposes. Several of our servers and 3 workstations are considered the designated MCP machines where our devs work. Seeing as how we don't need to track those licenses as a part of compliance, I'd like to filter Microsoft products on those machines out while still being able to track non Microsoft products on those machines. The problem is how.

Looking at the software asset, I am not seeing a way to filter by machine or location as the software assets and software inventory only pull from software tables in the database. I need to tie into the machine tables somehow. Is there a way to filter in this manner natively? Has anyone run into this before?

Any help is appreciated.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Perhaps I'm going about this the wrong way.

What if I added any Microsoft applications on these servers and workstations to the total license count in the license asset for that particular application?

Would there be a way to automate that based on machine name and/or location (asset)?
Answered 03/15/2012 by: jfalace
Senior Yellow Belt

Please log in to comment
0
I believe you might need to write a custom SQL for the software side where it looks at the machine table and excludes those machines you don't wanted count. I would attach a label to those dev boxes and call it MCP or something and JOIN the two tables and exclude any machine that had MCP as a label.
Answered 03/15/2012 by: nshah
Red Belt

Please log in to comment
0
Thanks for your reply nshah.

Here's the script my SQL dev and I came up with that pulls Microsoft software present on the MCP label.

select M.NAME, S.DISPLAY_NAME FROM MACHINE M
JOIN MACHINE_LABEL_JT ML ON M.ID = ML.MACHINE_ID
JOIN LABEL L ON ML.LABEL_ID = L.ID
JOIN MACHINE_SOFTWARE_JT MS ON MS.MACHINE_ID = M.ID
JOIN SOFTWARE S ON S.ID = MS.SOFTWARE_ID
WHERE L.NAME = 'MCP' AND S.PUBLISHER LIKE '%Microsoft%'


How do we incorporate this into the front end? Is it only possible to add this to the software compliance report?

We took a look at the Complete Software Compliance report but weren't exactly sure how to incorporate our code into the built in one. We do realize we'd need to duplicate the built in to edit it.
Answered 03/15/2012 by: jfalace
Senior Yellow Belt

Please log in to comment
0
Do you want this as a report Jeff, or as a group you can use in some other way?

If you want a report, I suggest creating a new SQL report, and then paste the SQL in.

If you want it as a data set to use as required, you will want to create a Smart Label (I suggest with a single dummy match, and then paste your SQL in after)
Answered 03/15/2012 by: scottlutz
Orange Senior Belt

Please log in to comment
0
Hi Scott and thanks for your reply,

I would be able to use this in a Software label?

Original code for our Microsoft Windows 2008 Standard Software Label:
SELECT ID FROM SOFTWARE WHERE ( SOFTWARE.DISPLAY_NAME like '%Microsoft® Windows Server® 2008 Standard%')
Replace it with this:
select DISTINCT M.NAME FROM MACHINE M
JOIN MACHINE_LABEL_JT ML ON M.ID = ML.MACHINE_ID
JOIN LABEL L ON ML.LABEL_ID = L.ID
JOIN MACHINE_SOFTWARE_JT MS ON MS.MACHINE_ID = M.ID
JOIN SOFTWARE S ON S.ID = MS.SOFTWARE_ID
WHERE M.ID NOT IN (SELECT MACHINE_ID FROM MACHINE_LABEL_JT WHERE LABEL_ID IN (SELECT ID FROM LABEL WHERE NAME = 'MCP'))
AND S.DISPLAY_NAME like '%Microsoft® Windows Server® 2008 Standard%'


And then do the same for all of our Microsoft software labels?
Answered 03/15/2012 by: jfalace
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity