Use this query to get the package name for any depended program.

See the TechNet forum post for full details.

SELECT     
  Pkg.Name AS 'Package Name', 
  ADV.ProgramName AS 'Program Name',
  ADV.AdvertisementName AS 'Advertisement Name', 
  Col.Name AS 'Collection Name', 
  CRQ.RuleName AS 'Security Group Name',
  Pgm.PackageID, 
  Pgm.ProgramName, 
  Pgm.DependentProgram,
  pkgsub.Name
  
FROM
  dbo.v_Advertisement Adv
  INNER JOIN dbo.v_Collection Col ON ADV.CollectionID = Col.CollectionID 
  INNER JOIN dbo.v_Package Pkg ON ADV.PackageID = Pkg.PackageID 
  INNER JOIN dbo.v_CollectionRuleQuery CRQ ON Col.CollectionID = CRQ.CollectionID 
  INNER JOIN dbo.v_Program Pgm ON Pkg.PackageID = Pgm.PackageID
  left outer Join (select substring(Pgm.DependentProgram,0,9) as Subpac, PackageID from dbo.v_Program  Pgm where Pgm.DependentProgram != '') sub ON sub.PackageID = Pkg.PackageID 
  left outer JOIN dbo.v_Package Pkgsub ON sub.Subpac = Pkgsub.PackageID 
--where 
--  ADV.AdvertisementName like 'Z7_%' 
ORDER BY 
  ADV.AdvertisementName

Congratulations to Scott K. for winning Enhansoft’s Foolish Chicken restaurant gift certificate at DevTeach.

Part 3

How to change a Data source on an existing SSRS Report:

1. Open Internet Explorer
2. URL: http://%reportserver%/reports
3. Select the report
4. Click on the Properties tab
5. From the menus on the left, select Data Sources
6. To use the Microsoft Data source, select a Shared Data Source
7. Click Browse and search under your report server for the following:

8. Click on OK at the bottom of this screen

9. Click on Apply at the bottom of the last screen.

This post will be the first in our series of Did You Know...

All of the log files associated with our Enhansoft products (Monitor Information Reporting, Warranty Information Reporting, Enhanced Web Reporting and Enhanced Network Device Discovery) are SMS Trace compliant and can be found in one of the following locations: %WINDIR%\System32\CCM\Logs folder, %WINDIR%\SysWOW64\CCM\Logs (for x64 OS) or in the temp file.

Today is the last day to request the winner of this month’s free SSRS report give-away - Advertisement Home Page Report.

Please contact info@enhansoft.com for a free license key.  Let us know what you think about this report. Thanks!

Enhansoft will be giving away one free SSRS report during the month of April. You can choose which report it will be - Package Status Report or Windows Experience Index Report.

Go to:

http://support.enhansoft.com/Forum/default.aspx?g=posts&t=29

and click on either Package Status or Windows Experience Index to register your vote by March 31. For more information about these reports read our March 2 and March 3 blog posts.

Thank you to everyone who dropped by Enhansoft’s booth at this year’s MMS Conference.   Today is our last day, so if you still haven’t dropped by, please do. It was great to meet so many of you and to catch-up with good friends and colleagues.  The myITforum Party was a blast (a special thank you to Rod Trent and his team for organizing this annual event), and our Chief Architect, Garth Jones, once again, wasn’t stumped on the “Ask the Expert” panel.  Here’s a photo of Enhansoft’s MMS-2011 booth at the Mandalay Bay Conference Center in Las Vegas.

Enhansoft is pleased to announce that it is a co-sponsor of the myITforum.com Party at MMS-2011.

The myITforum.com Party will take place on Tuesday, March 22 from 6 to 9 p.m. in Islanders D-E-I, which is in the North Convention Center (MMS-2011 is situated in the South Convention Center, levels 2 & 3) of Mandalay Bay Resort and Casino.

To get into the party you need a ticket. If you don’t already have a reserved ticket, make sure you pick one up at the myITforum.com booth #145 when the Expo opens at 5:30 p.m. on Monday, March 21. A limited number of tickets will be handed out at the myITforum.com booth on a first come, first serve basis.

Hope to see you there!

I encourage everybody whose OS is primarily Windows Vista or Windows 7 to vote for Enhansoft's Windows Experience Index Report. The WEI is a great tool to help you understand how well Windows is performing on your PC.

**Reminder – Feb. 28, 2011 is your last chance to vote for Enhansoft’s next SSRS report give-away:

Advertisement Home or Health Component.

Please click on the attached link to vote:  http://support.enhansoft.com/Forum/default.aspx?g=posts&m=57#post57

**Reminder – Feb. 28, 2011 is also your last chance to request a license key for our latest free report give-away - Software Distribution Status Report.  Please e-mail info@enhansoft.com to request a license key.