1. Open SQL Server Management Studio (or your SQL query tool).
2. Replace 'HostnameHere' with the desired computer hostname in the SET @HostnameValue line.
3. Execute the query.

DECLARE @HostnameValue VARCHAR(50);
SET @HostnameValue = <SelectedValue>;


use Snowlicensemanager

SELECT DISTINCT           

C.HostName         

,Soft.[SoftwareCheckSum]         

,Soft.[Name]       

  ,Soft.[Manufacturer]         

,Soft.[Language]         

,Soft.[Version]       

  ,Soft.[OSType]         

,Soft.[Executable]         

,Soft.[ExecutablePath]         

,Soft.[IsOS]         

,Soft.[IsHidden]       

 ,(SELECT r.RuleName FROM tblApplicationRule r WHERE r.RuleID = sam.RuleID ) as RuleApplied         

,Soft.[AddedDate]         

,Soft.[IsRegistry]   

 FROM [dbo].[tblSoftware] Soft   

INNER JOIN [dbo].[tblSoftwareApplicationMap] sam

ON sam.SoftwareCheckSum = Soft.SoftwareCheckSum   

INNER JOIN tblComputerSoftware cs

ON cs.SoftwareCheckSum = Soft.SoftwareCheckSum   

left join tblComputer as C on cs.ComputerID = c.ComputerID   

WHERE c.hostname LIKE @HostnameValue    ORDER BY soft.Name