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...