Select Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblSoftware.softwareVersion As Version,
Case
WHEN tblSoftwareUni.softwareName LIKE 'Coldfusion' AND tblSoftware.softwareVersion LIKE '11.%' THEN DateFromParts(2019, 04, 30)
WHEN tblSoftwareUni.softwareName LIKE 'Coldfusion' AND tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 05, 16)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Correspondence%Management%' And tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Designer%ES3%' AND tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%signature%ES3%' AND tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Connector%ES3%Documentum%' And tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Connector%ES3%Content%Manager%' AND tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Connector%ES3%FileNet%' And tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Connector%ES3%SharePoint%' And tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Forms%ES3%' AND tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Output%ES3%' AND tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Process%Management%ES3%' And tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Reader%ES3%' AND tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Rights%ES3%' AND tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%LiveCycle%Workbench%ES3%' AND tblSoftware.softwareVersion LIKE '10.%' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%Apache%Struts%' AND tblSoftware.softwareVersion LIKE '2.3.%' THEN DateFromParts(2019, 05, 14)
WHEN tblSoftwareUni.softwareName LIKE '%Bitbucket%' AND tblSoftware.softwareVersion LIKE '4.13' THEN DateFromParts(2019, 01, 20)
WHEN tblSoftwareUni.softwareName LIKE '%Bitbucket%' AND tblSoftware.softwareVersion LIKE '4.14' THEN DateFromParts(2019, 02, 21)
WHEN tblSoftwareUni.softwareName LIKE '%Bitbucket%' AND tblSoftware.softwareVersion LIKE '5.0' THEN DateFromParts(2019, 05, 02)
WHEN tblSoftwareUni.softwareName LIKE '%Bitbucket%' AND tblSoftware.softwareVersion LIKE '5.1' THEN DateFromParts(2019, 06, 06)
WHEN tblSoftwareUni.softwareName LIKE '%Confluence%' AND tblSoftware.softwareVersion LIKE '6.1' THEN DateFromParts(2019, 03, 20)
WHEN tblSoftwareUni.softwareName LIKE '%Confluence%' AND tblSoftware.softwareVersion LIKE '6.2' THEN DateFromParts(2019, 05, 15)
WHEN tblSoftwareUni.softwareName LIKE '%Jira%Core%' AND tblSoftware.softwareVersion LIKE '7.3' THEN DateFromParts(2019, 01, 03)
WHEN tblSoftwareUni.softwareName LIKE '%Jira%Core%' AND tblSoftware.softwareVersion LIKE '7.4' THEN DateFromParts(2019, 06, 29)
WHEN tblSoftwareUni.softwareName LIKE '%Jira%Service%' AND tblSoftware.softwareVersion LIKE '3.3' THEN DateFromParts(2019, 01, 03)
WHEN tblSoftwareUni.softwareName LIKE '%Jira%Service%' AND tblSoftware.softwareVersion LIKE '3.4' THEN DateFromParts(2019, 03, 14)
WHEN tblSoftwareUni.softwareName LIKE '%Jira%Service%' AND tblSoftware.softwareVersion LIKE '3.5' THEN DateFromParts(2019, 04, 27)
WHEN tblSoftwareUni.softwareName LIKE '%Jira%Service%' AND tblSoftware.softwareVersion LIKE '3.6' THEN DateFromParts(2019, 06, 29)
WHEN tblSoftwareUni.softwareName LIKE '%Jira%Software%' AND tblSoftware.softwareVersion LIKE '7.3' THEN DateFromParts(2019, 01, 03)
WHEN tblSoftwareUni.softwareName LIKE '%Jira%Software%' AND tblSoftware.softwareVersion LIKE '7.4' THEN DateFromParts(2019, 06, 29)
WHEN tblSoftwareUni.softwareName LIKE '%Endpoint%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Checkpoint%' AND tblSoftware.softwareVersion In ('%80.61', '%80.63', '%80.65', '%80.66', '%80.67', '%80.68', '%80.69') THEN DateFromParts(2018, 11, 01)
WHEN tblSoftwareUni.softwareName LIKE '%Endpoint%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Checkpoint%' AND tblSoftware.softwareVersion LIKE '%5.6' THEN DateFromParts(2019, 06, 01)
WHEN tblSoftwareUni.softwareName LIKE '%WebEx%Meetings%Server%' AND tblSoftware.softwareVersion LIKE '2.8' THEN DateFromParts(2019, 00, 20)
WHEN tblSoftwareUni.softwareName LIKE '%WebEx%Meetings%Suite%' AND tblSoftware.softwareVersion LIKE '32.12.%' THEN DateFromParts(2019, 01, 11)
WHEN tblSoftwareUni.softwareName LIKE '%WebEx%Meetings%Suite%' AND tblSoftware.softwareVersion LIKE '32.%.%' THEN DateFromParts(2019, 05, 24)
WHEN tblSoftwareUni.softwareName LIKE '%Websense%URL%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Forcepoint%' AND tblSoftware.softwareVersion In ('7.0', '7.1', '7.5') THEN DateFromParts(2019, 04, 02)
WHEN tblSoftwareUni.softwareName LIKE '%Websense%Express%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Forcepoint%' AND tblSoftware.softwareVersion LIKE '1.0.0' THEN DateFromParts(2019, 03, 31)
WHEN tblSoftwareUni.softwareName LIKE '%Jboss%Web%' AND tblSoftware.softwareVersion LIKE '1.%' THEN DateFromParts(2020, 04, 01)
WHEN tblSoftwareUni.softwareName LIKE '%Mediawiki%' AND tblSoftware.softwareVersion LIKE '1.27.%' THEN DateFromParts(2019, 06, 01)
WHEN tblSoftwareUni.softwareName LIKE '%Exchange%2010%' THEN DateFromParts(2020, 01, 14)
WHEN tblSoftwareUni.softwareName LIKE '%syslog-ng%' AND tblSoftware.softwareVersion LIKE '7.0.7' THEN DateFromParts(2019, 02, 25)
WHEN tblSoftwareUni.softwareName LIKE '%syslog-ng%' AND tblSoftware.softwareVersion LIKE '7.0.8' THEN DateFromParts(2019, 04, 22)
WHEN tblSoftwareUni.softwareName LIKE '%syslog-ng%' AND tblSoftware.softwareVersion LIKE '7.0.9' THEN DateFromParts(2019, 06, 19)
WHEN tblSoftwareUni.softwareName LIKE '%syslog-ng%' AND tblSoftware.softwareVersion LIKE '7.0.10' THEN DateFromParts(2019, 08, 19)
WHEN tblSoftwareUni.softwareName LIKE '%Compliance%manager%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '5.17.3' THEN DateFromParts(2019, 01, 01)
WHEN tblSoftwareUni.softwareName LIKE '%Compliance%manager%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '5.17.4' THEN DateFromParts(2019, 04, 01)
WHEN tblSoftwareUni.softwareName LIKE '%Compliance%manager%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '5.17.5' THEN DateFromParts(2019, 06, 01)
WHEN tblSoftwareUni.softwareName LIKE '%Connect%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '3.5' THEN DateFromParts(2019, 05, 01)
WHEN tblSoftwareUni.softwareName LIKE '%Enterprise%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '8.5.3' THEN DateFromParts(2019, 03, 01)
WHEN tblSoftwareUni.softwareName LIKE '%Enterprise%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '8.5.4' THEN DateFromParts(2019, 06, 01)
WHEN tblSoftwareUni.softwareName LIKE '%IP360%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '8.1.1' THEN DateFromParts(2019, 05, 01)
WHEN tblSoftwareUni.softwareName LIKE '%log%center%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '7.2.4' THEN DateFromParts(2019, 03, 01)
WHEN tblSoftwareUni.softwareName LIKE '%log%center%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '7.2.5' THEN DateFromParts(2019, 06, 01)
WHEN tblSoftwareUni.softwareName LIKE '%Intelligence%hub%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '2.7.3' THEN DateFromParts(2019, 03, 01)
WHEN tblSoftwareUni.softwareName LIKE '%Winzip%' AND tblSoftware.softwareVersion LIKE '20%' THEN DateFromParts(2019, 04, 30)
WHEN tblSoftwareUni.softwareName LIKE '%Horizon%' AND tblSoftwareUni.SoftwarePublisher LIKE '%vmware%' AND tblSoftware.softwareVersion LIKE '6.%' THEN DateFromParts(2019, 06, 19)
WHEN tblSoftwareUni.softwareName LIKE '%Expression%Blend%3%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 01, 14)
WHEN tblSoftwareUni.softwareName LIKE '%Expression%Design%3%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 01, 14)
WHEN tblSoftwareUni.softwareName LIKE '%Expression%Encoder%3%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 01, 14)
WHEN tblSoftwareUni.softwareName LIKE '%Expression%Studio%3%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 01, 14)
WHEN tblSoftwareUni.softwareName LIKE '%Expression%Web%3%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 01, 14)
WHEN tblSoftwareUni.softwareName LIKE '%Forefront%Unified%Access%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 04, 14)
WHEN tblSoftwareUni.softwareName LIKE '%Forefront%Threat%management%2010%' And tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 04, 14)
WHEN tblSoftwareUni.softwareName LIKE '%Visual%Studio%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 07, 14)
WHEN tblSoftwareUni.softwareName LIKE '%Expression%Encoder%4%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 09, 08)
WHEN tblSoftwareUni.softwareName LIKE '%Expression%Web%4%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 09, 08)
WHEN tblSoftwareUni.softwareName LIKE '%Acess%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%Dynamics%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%Excel%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%Expression%Studio%4%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%Infopath%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%Office%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%Onenote%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%Outlook%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%powerpoint%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%project%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%publisher%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%sharepoint%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%visio%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%visual%basic%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
WHEN tblSoftwareUni.softwareName LIKE '%word%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' THEN DateFromParts(2020, 10, 13)
End As [EOS date],
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftware.Lastchanged
From
tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where
(tblSoftwareUni.softwareName LIKE 'Coldfusion' AND (tblSoftware.softwareVersion LIKE '11.%' Or tblSoftware.softwareVersion LIKE '10.%'))
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Correspondence%Management%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Designer%ES3%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%signature%ES3%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Connector%ES3%Documentum%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Connector%ES3%Content%Manager%' And tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Connector%ES3%FileNet%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Connector%ES3%SharePoint%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Forms%ES3%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Output%ES3%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Process%Management%ES3%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Reader%ES3%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Rights%ES3%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%LiveCycle%Workbench%ES3%' AND tblSoftware.softwareVersion LIKE '10.%')
OR (tblSoftwareUni.softwareName LIKE '%Apache%Struts%' AND tblSoftware.softwareVersion LIKE '2.3.%')
OR (tblSoftwareUni.softwareName LIKE '%Bitbucket%' AND tblSoftware.softwareVersion In ('4.13', '4.14', '5.0', '5.1'))
OR (tblSoftwareUni.softwareName LIKE '%Confluence%' AND tblSoftware.softwareVersion In ('6.1', '6.2'))
OR (tblSoftwareUni.softwareName LIKE '%Jira%Core%' AND tblSoftware.softwareVersion In ('7.3', '7.4'))
OR (tblSoftwareUni.softwareName LIKE '%Jira%Service%' AND tblSoftware.softwareVersion In ('3.3', '3.4', '3.5', '3.6'))
OR (tblSoftwareUni.softwareName LIKE '%Jira%Software%' AND tblSoftware.softwareVersion In ('7.3', '7.4'))
OR (tblSoftwareUni.softwareName LIKE '%Endpoint%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Checkpoint%' AND tblSoftware.softwareVersion In ('%80.61', '%80.63', '%80.65', '%80.66', '%80.67', '%80.68', '%80.69', '%5.6'))
OR (tblSoftwareUni.softwareName LIKE '%WebEx%Meetings%Server%' AND tblSoftware.softwareVersion LIKE '2.8')
OR (tblSoftwareUni.softwareName LIKE '%WebEx%Meetings%Suite%' AND tblSoftware.softwareVersion In ('32.12.%', '32.%.%'))
OR (tblSoftwareUni.softwareName LIKE '%Websense%URL%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Forcepoint%' AND tblSoftware.softwareVersion In ('7.0', '7.1', '7.5'))
OR (tblSoftwareUni.softwareName LIKE '%Websense%Express%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Forcepoint%' AND tblSoftware.softwareVersion LIKE '1.0.0')
OR (tblSoftwareUni.softwareName LIKE '%Jboss%Web%' AND tblSoftware.softwareVersion LIKE '1.%')
OR (tblSoftwareUni.softwareName LIKE '%Mediawiki%' AND tblSoftware.softwareVersion LIKE '1.27.%')
OR (tblSoftwareUni.softwareName LIKE '%Exchange%2010%')
OR (tblSoftwareUni.softwareName LIKE '%syslog-ng%' AND tblSoftware.softwareVersion In ('7.0.7', '7.0.8', '7.0.9', '7.0.10'))
OR (tblSoftwareUni.softwareName LIKE '%Compliance%manager%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion In ('5.17.3', '5.17.4', '5.17.5'))
OR (tblSoftwareUni.softwareName LIKE '%Connect%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '3.5')
OR (tblSoftwareUni.softwareName LIKE '%Enterprise%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion In ('8.5.3', '8.5.4'))
OR (tblSoftwareUni.softwareName LIKE '%IP360%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '8.1.1')
OR (tblSoftwareUni.softwareName LIKE '%log%center%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion In ('7.2.4', '7.2.5'))
OR (tblSoftwareUni.softwareName LIKE '%Intelligence%hub%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Tripwire%' AND tblSoftware.softwareVersion LIKE '2.7.3')
OR (tblSoftwareUni.softwareName LIKE '%Winzip%' AND tblSoftware.softwareVersion LIKE '20%')
OR (tblSoftwareUni.softwareName LIKE '%Horizon%' AND tblSoftwareUni.SoftwarePublisher LIKE '%vmware%' AND tblSoftware.softwareVersion LIKE '6.%')
OR (tblSoftwareUni.softwareName LIKE '%Expression%Blend%3%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Expression%Design%3%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Expression%Encoder%3%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Expression%Studio%3%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Expression%Web%3%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Forefront%Unified%Access%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Forefront%Threat%management%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Visual%Studio%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Expression%Encoder%4%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Expression%Web%4%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Acess%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Dynamics%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Excel%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Expression%Studio%4%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Infopath%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Office%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Onenote%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%Outlook%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%powerpoint%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%project%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%publisher%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%sharepoint%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%visio%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%visual%basic%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%')
OR (tblSoftwareUni.softwareName LIKE '%word%2010%' AND tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%' And tblState.Statename = 'Active')
Order By
tblAssets.Domain,
tblAssets.AssetName