SQL版本

步骤一： 登录用户的帐户信息

输入:	loginid='m******n'(登录名)
输出:	userid='M******N'(帐户名)
	defsite='BEDFORD'(默认的资产所在站点)
	storeroomsite='BEDFORD'(库存所在的站点)
select
	userid,personid,defsite,storeroomsite
from
	maxuser
Where
	loginid='m******n'
	and status='ACTIVE';

步骤二：所在站点的资产所在站点的资产

输入:	siteid='BEDFORD'
输出:
select
  *
from
	asset
where
	siteid='BEDFORD'

OSLC版本

m****osoapuiprojs

后台已有的OSLC服务

[名称]
登录用户的站点
[URL]
http://localhost:9080/eam/oslc/os/oslcmaxuser?oslc.select=spi:defsite&oslc.where=spi:loginid="maxadmin"
[header]
MAXAUTH		bWF4YWRtaW46bWF4QWRtaW4xMjM=
	[result]
"spi:defsite": {"rdf:resource": "http://eam.com/eam/oslc/os/oslcsite/_QkVERk9SRA--"}

[名称]
站点的名称和组织
[URL]
http://localhost:9080/eam/oslc/os/oslcsite/_QkVERk9SRA--?oslc.select=oslc:shortTitle
[header]
MAXAUTH		bWF4YWRtaW46bWF4QWRtaW4xMjM=
	[result]
"oslc:shortTitle": "BEDFORD"

[名称]
资产中隶属站点的资产
[备注]
oslc.select=*	选取显示所有的项
[URL]
http://localhost:9080/eam/oslc/os/oslcasset?oslc.select=spi:assetid,oslc:shortTitle,spi:itemtype&oslc.where=spi:siteid="BEDFORD"&oslc.pageSize=3&oslc.orderBy=-spi:assetid
[header]
MAXAUTH		bWF4YWRtaW46bWF4QWRtaW4xMjM=
[result]
{
	"oslc:responseInfo":    {
		"oslc:totalCount": 536,
			"oslc:nextPage": {"rdf:resource": "http://eam.com/eam/oslc/os/oslcasset?pageno=2&oslc.where=spi%3Asiteid%3D%22BEDFORD%22&oslc.pageSize=3&oslc.orderBy=-spi%3Aassetid&oslc.select=spi%3Aassetid%2Coslc%3AshortTitle%2Cspi%3Aitemtype"},
				"rdf:about": "http://eam.com/eam/oslc/os/oslcasset?oslc.select=spi%3Aassetid%2Coslc%3AshortTitle%2Cspi%3Aitemtype&oslc.where=spi%3Asiteid%3D%22BEDFORD%22&oslc.pageSize=3&oslc.orderBy=-spi%3Aassetid"
	},
		"rdf:type": [{"rdf:resource": "http://www.w3.org/2000/01/rdf-schema#Container"}],
			"rdfs:member":    [
				{
					"spi:assetid": 1669,
					"oslc:shortTitle": "2111",
					"rdf:about": "http://eam.com/eam/oslc/os/oslcasset/_MjExMS9CRURGT1JE",
					"spi:itemtype": "ITEM"
				},
				{
					"spi:assetid": 1668,
					"oslc:shortTitle": "2110",
					"rdf:about": "http://eam.com/eam/oslc/os/oslcasset/_MjExMC9CRURGT1JE",
					"spi:itemtype": "ITEM"
				},
				{
					"spi:assetid": 1667,
					"oslc:shortTitle": "2109",
					"rdf:about": "http://eam.com/eam/oslc/os/oslcasset/_MjEwOS9CRURGT1JE",
					"spi:itemtype": "ITEM"
				}
			],
				"rdf:about": "http://eam.com/eam/oslc/os/oslcasset",
					"prefixes":    {
						"rdfs": "http://www.w3.org/2000/01/rdf-schema#",
							"spi": "http://jazz.net/ns/ism/asset/smarter_physical_infrastructure#",
								"oslc": "http://open-services.net/ns/core#",
									"rdf": "http://www.w3.org/1999/02/22-rdf-syntax-ns#"
					}
}