[dbo].[pubsumcomputers]

(local) > mdb > Views > dbo.pubsumcomputers

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:20 AM Wednesday, March 07, 2007
Last Modified	4:54:36 PM Tuesday, May 05, 2009

Columns

Name
count
pubname

Permissions

Type	Action	Owning Principal
Grant	Select	aiadmin
Grant	Select	aipublic

SQL Script

CREATE view  pubsumcomputers AS SELECT COUNT(*) AS "count", ai_pubdef_prop.pubname FROM  ai_swdef_prop INNER JOIN  ai_pubdef_prop ON ai_swdef_prop.pubuuid = ai_pubdef_prop.pubuuid INNER JOIN  ai_swdef_instcnt_kpi ON ai_swdef_prop.swuuid = ai_swdef_instcnt_kpi.swuuid GROUP BY ai_pubdef_prop.pubname
GO
GRANT SELECT ON  [dbo].[pubsumcomputers] TO [aiadmin]
GRANT SELECT ON  [dbo].[pubsumcomputers] TO [aipublic]
GO

Uses

[dbo].[ai_pubdef_prop]
[dbo].[ai_swdef_instcnt_kpi]
[dbo].[ai_swdef_prop]
dbo