Sounds like a plan! Daniel Ratliff
From: listsadmin@lists.myitforum.com [mailto:listsadmin@lists.myitforum.com] On Behalf Of Garth Jones Sent: Thursday, March 31, 2016 2:01 PM To: ms...@lists.myitforum.com Subject: [mssms] RE: Microsoft True Up Report Lol, no need to do that, how about you "buy" me a beer<http://mms2016.sched.org/type/beer?iframe=no&w=&sidebar=no&bg=no> on Monday/Tuesday night? ;-) From: listsadmin@lists.myitforum.com<mailto:listsadmin@lists.myitforum.com> [mailto:listsadmin@lists.myitforum.com] On Behalf Of Daniel Ratliff Sent: Thursday, March 31, 2016 1:15 PM To: ms...@lists.myitforum.com<mailto:ms...@lists.myitforum.com> Subject: [mssms] RE: Microsoft True Up Report Lunch is on me for sure Garth. At this point I could probably owe you about 100 lunches. Daniel Ratliff From: listsadmin@lists.myitforum.com<mailto:listsadmin@lists.myitforum.com> [mailto:listsadmin@lists.myitforum.com] On Behalf Of Garth Jones Sent: Thursday, March 31, 2016 1:06 PM To: ms...@lists.myitforum.com<mailto:ms...@lists.myitforum.com> Subject: [mssms] RE: Microsoft True Up Report So Did I get the $10 at MMS? :) From: listsadmin@lists.myitforum.com<mailto:listsadmin@lists.myitforum.com> [mailto:listsadmin@lists.myitforum.com] On Behalf Of Daniel Ratliff Sent: Thursday, March 31, 2016 12:23 PM To: ms...@lists.myitforum.com<mailto:ms...@lists.myitforum.com> Subject: [mssms] RE: Microsoft True Up Report I tried to find a nice explanation online, but couldn't. I know I even saw one a few weeks ago. $10 it came from Garth or Sherry. :) I will try my hand at it. If you enable software metering in the client settings, it will allow this view to report back on info gathered by the SWM agent. You can see this in C:\windows\ccm\logs\mtrmgr.log. Below I have opened Visio and you can see it identified the process, and we even have a SWM rule enabled for visio. Process ID 9192 is for process C:\Program Files (x86)\Microsoft Office\Office15\VISIO.EXE mtrmgr 3/31/2016 12:16:22 PM 4880 (0x1310) Found match against RuleID CAS00115 mtrmgr 3/31/2016 12:16:22 PM 180 (0x00B4) Tracked usage for process 9192 mtrmgr 3/31/2016 12:16:22 PM 180 (0x00B4) Creation event received for process 11148 mtrmgr 3/31/2016 12:16:25 PM 4880 (0x1310) If I open something we don't have a rule for, it still sees it and tracks it! Process ID 10544 is for process C:\WINDOWS\system32\cmtrace.exe mtrmgr 3/31/2016 12:14:36 PM 4880 (0x1310) Creation event received for process 2492 mtrmgr 3/31/2016 12:14:36 PM 4880 (0x1310) No matching rule found for process 10544 mtrmgr 3/31/2016 12:14:36 PM 180 (0x00B4) Here is a sample output from the view. As you can see it gets most file properties, with the most important column, LastUsedTime0. CompanyName0 ExplorerFileName0 FileDescription0 FilePropertiesHash0 FileSize0 FileVersion0 FolderPath0 LastUsedTime0 LastUserName0 OriginalFileName0 ProductName0 ProductVersion0 Microsoft Corporation cmtrace.exe Configuration Manager Trace Log Tool 6e9e8139b07c967f318a9bbb0aacfd3155854658adfdd3b9bdf7bf3fb1257413 638136 5.00.7958.1000 (hermbld.130911-1515) \\server\client<file://server/client> 3/1/16 2:12 PM Domain\user1 CMTraceLoader.exe System Center 2012 Configuration Manager 5.00.7958.1000 Microsoft Corporation cmtrace.exe Configuration Manager Trace Log Tool 6e9e8139b07c967f318a9bbb0aacfd3155854658adfdd3b9bdf7bf3fb1257413 638136 5.00.7958.1000 (hermbld.130911-1515) \\server\client<file://server/client> 3/4/16 6:41 PM Domain\user1 CMTraceLoader.exe System Center 2012 Configuration Manager 5.00.7958.1000 Microsoft Corporation cmtrace.exe Configuration Manager Trace Log Tool eab22b6f1272f37e669274012b962822501c1d96cf493bf9ef652f5bb4f8a7a9 678480 5.00.7804.1000 (hermbld.121121-2357) \\server\client<file://server/client> 10/22/15 5:23 PM Domain\user2 CMTraceLoader.exe System Center 2012 Configuration Manager 5.00.7804.1000 Microsoft Corporation cmtrace.exe Configuration Manager Trace Log Tool eab22b6f1272f37e669274012b962822501c1d96cf493bf9ef652f5bb4f8a7a9 678480 5.00.7804.1000 (hermbld.121121-2357) \\server\client<file://server/client> 2/10/15 7:44 PM Domain\user2 CMTraceLoader.exe System Center 2012 Configuration Manager 5.00.7804.1000 Microsoft Corporation cmtrace.exe Configuration Manager Trace Log Tool eab22b6f1272f37e669274012b962822501c1d96cf493bf9ef652f5bb4f8a7a9 678480 5.00.7804.1000 (hermbld.121121-2357) \\server\client<file://server/client> 8/11/15 6:31 PM Domain\user3 CMTraceLoader.exe System Center 2012 Configuration Manager 5.00.7804.1000 My only gap in the understanding is what the exact requirements are to gather this data. I know you need the SWM agent enabled, but I think there is a tie to the software inventory as well. I just don't know off hand. Daniel Ratliff From: listsadmin@lists.myitforum.com<mailto:listsadmin@lists.myitforum.com> [mailto:listsadmin@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Thursday, March 31, 2016 11:54 AM To: ms...@lists.myitforum.com<mailto:ms...@lists.myitforum.com> Subject: [mssms] Re: Microsoft True Up Report Thanks Daniel. How exactly does this work? ________________________________ From: listsadmin@lists.myitforum.com<mailto:listsadmin@lists.myitforum.com> <listsadmin@lists.myitforum.com<mailto:listsadmin@lists.myitforum.com>> on behalf of Daniel Ratliff <dratl...@humana.com<mailto:dratl...@humana.com>> Sent: Thursday, March 31, 2016 10:31 AM To: ms...@lists.myitforum.com<mailto:ms...@lists.myitforum.com> Subject: [mssms] RE: Microsoft True Up Report We base usage data off the v_gs_ccm_recently_used_software view. Works great. Also leveraging 1e AppClarity for normalization. Daniel Ratliff From: listsadmin@lists.myitforum.com<mailto:listsadmin@lists.myitforum.com> [mailto:listsadmin@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Thursday, March 31, 2016 11:17 AM To: ms...@lists.myitforum.com<mailto:ms...@lists.myitforum.com> Subject: [mssms] Microsoft True Up Report Good day, I have been tasked with putting together the Microsoft True Up report. I've been doing some searching online and it looks like folks are saying there are limitations with what you can do with Asset Intelligence. I saw a query posted by Garth here: http://smsug.ca/blogs/garth_jones/archive/2013/02/07/microsoft-true-up-report.aspx - Although the query isn't working at it states "@CollID - "Must declare the scalar variable "@CollID". Microsoft True Up Report - Garth Jones<http://smsug.ca/blogs/garth_jones/archive/2013/02/07/microsoft-true-up-report.aspx> smsug.ca Pingback from Microsoft True Up Report | My CMS. June 10, 2013 5:41 PM This Blog I'd like to know how others are doing True Up Reports? Is BDNA Normalize worth looking into? Here is another guide that looks very intriguing. http://myitforum.com/myitforumwp/2012/07/13/performing-a-software-true-up-in-under-5-minutes/ I would need to convince management to purchase the software, of course. Love to hear what people know about this to get me down the right path. Thank you, Brian M. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
