periicles

Hi Trydl, before I continue I would like to thanks you for your help

Regarding to the filter, that is correct I need to populate a filter with machine base on the NetBIOS name....

I tried the "Code" you mentioned and it worked good to get machine names....If I want to import machine from AD to filter, can I include a code here!!!!!! or better do it different way...

.................................

By the way, I would like to ask you one more question (sorry) about the code for Ip address. I wanted to include the IP information in different queries??? this time for a report for machines with altiris agent (see sample) but it did not work...sorry still learning.....how to include the variable for this query....

................start of sample............................
DECLARE @v1_TrusteeScope varchar(99)
SET @v1_TrusteeScope = '%TrusteeScope%'
IF %ResultType% = 1
SELECT DISTINCT TOP %N% vComputer.Guid AS '_ItemGuid', vComputer.Name, vComputer.Domain, vComputer.[OS Name], vComputer.Guid AS [Machine Guid], vComputer.Server
FROM Inv_AeX_AC_Client_Agent
INNER JOIN vComputer ON vComputer.Guid = Inv_AeX_AC_Client_Agent._ResourceGuid
INNER JOIN [fnGetTrusteeScopedResources](@v1_TrusteeScope) AS [fnGTSR_3] ON [vComputer].[Guid] = [fnGTSR_3].[ResourceGuid]
WHERE (vComputer.Domain LIKE '%Domain%') AND (vComputer.[OS Name] LIKE '%OSName%') AND (vComputer.Name LIKE '%Name%') AND
(UPPER(Inv_AeX_AC_Client_Agent.[Agent Name]) IN ('ALTIRIS EXPRESS NS CLIENT', 'ALTIRIS AGENT')) AND (vComputer.Guid IN
(SELECT vComputer.Guid
FROM Inv_AeX_AC_Client_Agent
INNER JOIN vComputer ON vComputer.Guid = Inv_AeX_AC_Client_Agent._ResourceGuid
WHERE (UPPER(Inv_AeX_AC_Client_Agent.[Agent Name]) IN ('ALTIRIS EXPRESS ACLIENT', 'DEPLOYMENT AGENT FOR WINDOWS (ACLIENT)'))))
............end of sample...........

Thanks in advance if you have the opportunity to reply....( In the meantime I am waiting for my boss to send me to some training for these sort of sql for altiris too....I hope soon)