With this blog entry I'm starting to post short troubleshooting tips/steps for Deployment Solution.
Some of the information I'm puting to these blog post will be most likely in our KB system as well but I hope there will be information/steps that can be useful for users who are not yet very familiar with Deployment Solution 7.1 and need to do some troubleshooting.
I'll start this blog series with basic troubleshooting steps for Package Server.
1- Verify if the computer is in a site
DECLARE @cName varchar(64)
SET @cName = 'Computer Name' -- Name of the target computer
SELECT DISTINCT i2.name as Site, c.Name as Computer, s.Subnet, s.[Subnet Mask], c.guid
FROM dbo.Inv_AeX_AC_TCPIP t
JOIN dbo.vSubnet s
JOIN dbo.vItem i
JOIN dbo.vSiteSubnetMap sm
ON i.Guid = sm._ResourceGuid