Dynamic Application Deployment – Based upon Add/Remove Programs History

I’ve worked alot with Dynamic Application Deployment over the past few months.  The documentation in the MDT toolkit is pretty good, but I did need to change the query to suite my needs.  The default query uses ProdID0 in the database, i found that DisplayName0 makes alot more sense, since that is what you actually “see” when you look at the ARP in Control Panel.

Also to note, that i’ve found it’s a good idea to always make sure you specify your SQLShare property for all your database sections in your customsettings.ini, it’s also a good idea to use a differen share from your logs, i just use a generic SQL$ share that isn’t linked to anything else.  Otherwise I’ve seen some errors on the logs because another process owns that share.

So your new stored procedure would be:

CREATE PROCEDURE [dbo].[RetrievePackages]

@MacAddress CHAR(17)

AS

SET NOCOUNT ON

/* Select and return all the appropriate records based on current inventory */

SELECT * FROM PackageMapping

WHERE ARPName IN

(

SELECT DisplayName0 FROM SMS_SZ0.dbo.v_GS_ADD_REMOVE_PROGRAMS a, SMS_SZ0.dbo.v_GS_NETWORK_ADAPTER n

WHERE a.ResourceID = n.ResourceID AND

MACAddress0 = @MacAddress

)

GO

If you have any questions, feel free to contact me…