EA Usage stats

[Geert Bellekens]

You can get

- Last user logged => no
- Last item modified => (if it's an element or a diagram)
- Last item modified date => (for an element or a diagram)
- Package numbers in the repo => yes
- Security enabled yes / no => yes
- Audit enabled yes / no => yes
- Versioning enabled yes / no => yes

Geert

[Typia]

You can get

- Last user logged => no
- Last item modified => (if it's an element or a diagram)
- Last item modified date => (for an element or a diagram)
- Package numbers in the repo => yes
- Security enabled yes / no => yes
- Audit enabled yes / no => yes
- Versioning enabled yes / no => yes

Geert

Hi Geert thanks for your answer,
If you have queries for those purpose I'm in !

[Modesto Vega]

This 2 queries should give you the last modified elements and diagrams in the repository and the number of packages, including root nodes, in the repository (from t_package instead of t_element).

Code: [Select]

SELECT Object_ID AS ID, 'Element.' & Object_Type AS Type, Name, ModifiedDate
FROM t_object
WHERE ModifiedDate = (SELECT MAX(ModifiedDate) FROM t_object)
UNION ALL
SELECT Diagram_ID, 'Diagram.' & Diagram_Type, Name, ModifiedDate FROM t_diagram
WHERE ModifiedDate = (SELECT MAX(ModifiedDate) FROM t_diagram)

Code: [Select]

SELECT count(*) FROM t_package

[Typia]

This 2 queries should give you the last modified elements and diagrams in the repository and the number of packages, including root nodes, in the repository (from t_package instead of t_element).

Code: [Select]

SELECT Object_ID AS ID, 'Element.' & Object_Type AS Type, Name, ModifiedDate
FROM t_object
WHERE ModifiedDate = (SELECT MAX(ModifiedDate) FROM t_object)
UNION ALL
SELECT Diagram_ID, 'Diagram.' & Diagram_Type, Name, ModifiedDate FROM t_diagram
WHERE ModifiedDate = (SELECT MAX(ModifiedDate) FROM t_diagram)

Code: [Select]

SELECT count(*) FROM t_package

Hi Modesto,
thanks a lot for your answer.
When I run the first query, I have an error message : " The data types varchar and nvarchar are incompatible in the '&' operator. "
I run it from sql management studio directly connected to database.

[qwerty]

https://stackoverflow.com/questions/14055400/sql-server-datatypes-nvarchar-and-varchar-are-incompatible-error

q.

[Typia]

https://stackoverflow.com/questions/14055400/sql-server-datatypes-nvarchar-and-varchar-are-incompatible-error

q.

thanks a lot !!

[qwerty]

Google is always (well, in certain conditions) your friend. Strange error message? Just google and see if it hits StackOverflow :-)

q.