Hello everyone.

Please help in the following scenario:

I have several servers from specific AD domain assinged to some site.

I can see these servers on the http://<sd_ip>/WorkstationListView.do?isServer=true. There are 8 servers.

I created report with following query. And this report shows only 2 servers. The rest 6 servers are shown in the Workstations block.

SELECT productType.COMPONENTTYPENAME "Product Type",resource.RESOURCENAME "Resource Name",productType.COMPONENTTYPENAME "Product Type",state.DISPLAYSTATE "Resource State",aaaUser.FIRST_NAME "User",resFields.UDF_CHAR1 "Инвентарный номер",resFields.UDF_CHAR2 "Внутренний номер",aaov.NAME "Site" FROM Resources resource LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID LEFT JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID LEFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID LEFT JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID LEFT JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID LEFT JOIN Resource_Fields resFields ON resource.RESOURCEID=resFields.RESOURCEID WHERE (((productType.COMPONENTTYPENAME != N'Software' COLLATE Cyrillic_General_CI_AS) OR (productType.COMPONENTTYPENAME IS NULL)) AND (aaov.NAME = N'site_name' COLLATE Cyrillic_General_CI_AS)) ORDER BY 1, 4, 2

Do you have any suggestions?

Thanks.