Hi,
ich verzweifle an einem Report über Assets, gruppiert nach Standorten und Räumen.
Hat jemand für mich einen Dataset + Layout ansatz?
Mein größtes Denkproblem ist das SQL Statement...wie bekomme ich in den JOIN auf die SPSLocationClassBase nur auf .Type 4 und 6 hin?
***
Ausgabebeispiel:
Standort 1
Raum 1
Asset 1
Asset 2
Asset 3
Raum 2
Asset 4
Asset 5
Standort 2
Raum 3
Asset 6
...
***
Standort: SPSLocationClassBase.type=4
Raum: SPSLocationClassBase.type=6
***
SELECT asset.objectid
, comp.name
, loc.Name
, loc.Type
FROM
SPSComputerClassBase comp
LEFT JOIN SPSAssetClassBase asset ON comp.[Expression-ObjectID] = asset.[Expression-ObjectID]
LEFT JOIN SPSCommonClassBase comm ON asset.[Expression-ObjectID] = comm.[Expression-ObjectID]
Assetreport nach Standorten und Räumen
Re: Assetreport nach Standorten und Räumen
Sorry…was vergessen =)
***
SELECT asset.objectid
, comp.name
, loc.Name
, loc.Type
, parent.name
, parent.ID
FROM
SPSComputerClassBase comp
LEFT JOIN SPSAssetClassBase asset ON comp.[Expression-ObjectID] = asset.[Expression-ObjectID]
LEFT JOIN SPSLocationClassBase loc ON asset.[Expression-ObjectID] = loc.[Expression-ObjectID]
LEFT JOIN SPSCommonClassBase comm ON asset.[Expression-ObjectID] = comm.[Expression-ObjectID]
LEFT JOIN SPSLocationClassBase parent ON comm.Location = parent.ID
***
SELECT asset.objectid
, comp.name
, loc.Name
, loc.Type
, parent.name
, parent.ID
FROM
SPSComputerClassBase comp
LEFT JOIN SPSAssetClassBase asset ON comp.[Expression-ObjectID] = asset.[Expression-ObjectID]
LEFT JOIN SPSLocationClassBase loc ON asset.[Expression-ObjectID] = loc.[Expression-ObjectID]
LEFT JOIN SPSCommonClassBase comm ON asset.[Expression-ObjectID] = comm.[Expression-ObjectID]
LEFT JOIN SPSLocationClassBase parent ON comm.Location = parent.ID
Re: Assetreport nach Standorten und Räumen
Hallo,
versuch es mal mit der Abfrage:
SELECT
asset.objectid
, comp.name
, loc.Name
, loc.Type
, parent.name
, parent.ID
FROM
SPSComputerClassBase comp
LEFT JOIN SPSAssetClassBase asset ON comp.[Expression-ObjectID] = asset.UsedInTypeSPSComputerType
LEFT JOIN SPSCommonClassBase comm ON asset.[Expression-ObjectID] = comm.[Expression-ObjectID]
LEFT JOIN SPSLocationClassBase loc ON loc.ID = comm.Location
LEFT JOIN SPSLocationClassBase parent ON comm.Location = parent.ID
WHERE loc.Type = '4' or loc.Type = '6'
Geruß Dirk
versuch es mal mit der Abfrage:
SELECT
asset.objectid
, comp.name
, loc.Name
, loc.Type
, parent.name
, parent.ID
FROM
SPSComputerClassBase comp
LEFT JOIN SPSAssetClassBase asset ON comp.[Expression-ObjectID] = asset.UsedInTypeSPSComputerType
LEFT JOIN SPSCommonClassBase comm ON asset.[Expression-ObjectID] = comm.[Expression-ObjectID]
LEFT JOIN SPSLocationClassBase loc ON loc.ID = comm.Location
LEFT JOIN SPSLocationClassBase parent ON comm.Location = parent.ID
WHERE loc.Type = '4' or loc.Type = '6'
Geruß Dirk
Who is online
Users browsing this forum: Bing [Bot] and 5 guests