E
dit
A
ttach
P
rintable
r2 - 2021-04-01 - 13:20:10 -
TimFeeney
You are here:
TWiki
>
Deployment Web
>
DeploymentMonitoring
>
UsefulLQEQueries
<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! Useful LQE SPARQL Queries <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/todo.png" alt="todo.png" width="50" height="50" align="right"> %DKGRAY% Authors: Main.TimFeeney, Main.IanBarnard, Main.FabriceMendes <br> Build basis: 6.0.6.1 and above %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> This page contains some useful SPARQL queries to gather information from the LQE repository. These can be run from the [[https://www.ibm.com/support/knowledgecenter/SSYMRC_7.0.2/com.ibm.team.jp.lqe2.doc/topics/t_query.html][query interface]] of the LQE administration UI. Be advised that [[https://jazz.net/wiki/bin/view/Deployment/CLMExpensiveScenarios#Running_high_volume_and_very_com][complex and/or high volume queries can place load on the server]] so exercise caution and test these in a non-production environment first. ---++ Count components per project <verbatim> PREFIX oslc_config: <http://open-services.net/ns/config#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX dc: <http://purl.org/dc/terms/> PREFIX process: <http://jazz.net/ns/process#> SELECT ?project ?projectName ( COUNT ( ?fgc ) AS ?components ) WHERE { ?fgc rdf:type oslc_config:Component . ?fgc process:projectArea ?project . ?project dc:title ?projectName . } GROUP BY ?project ?projectName </verbatim> ---++ Total baselines and streams per component If you remove or adapt the filter line for /rm/ these will work with gc and probably qm; it won't work with context root like /rm1. <verbatim> PREFIX process: <http://jazz.net/ns/process#> PREFIX ns_validity_: <http://jazz.net/ns/validity#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX merge: <http://jazz.net/ns/lqe/merge/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX oslc_config: <http://open-services.net/ns/config#> PREFIX oslc: <http://open-services.net/ns/core#> SELECT DISTINCT ?projectArea ?projectTitle ?component ?componentTitle ?baselineCount ?streamCount WHERE { ?projectArea rdf:type process:ProjectArea. ?projectArea <http://open-services.net/ns/core#archived> false . FILTER regex(str(?projectArea),"/rm/") OPTIONAL { ?projectArea dcterms:title ?projectTitle. } ?component rdf:type oslc_config:Component . ?component <http://jazz.net/ns/process#projectArea> ?projectArea . OPTIONAL { ?component dcterms:title ?componentTitle. } OPTIONAL { SELECT DISTINCT (COUNT(DISTINCT ?oslc_config_Baseline1) AS ?baselineCount) ?component WHERE{ ?oslc_config_Baseline1_uri oslc_config:component ?component. ?oslc_config_Baseline1_uri rdf:type oslc_config:Baseline. OPTIONAL {?oslc_config_Baseline1_ver dcterms:isVersionOf ?oslc_config_Baseline1_uri; rdf:type oslc_config:VersionResource.} BIND( IF (bound(?oslc_config_Baseline1_ver), concat(str(?oslc_config_Baseline1_uri), "?oslc_config.context="), ?oslc_config_Baseline1_uri) as ?oslc_config_Baseline1) } GROUP BY ?component } OPTIONAL { SELECT DISTINCT (COUNT(DISTINCT ?oslc_config_Stream1) AS ?streamCount) ?component WHERE{ ?oslc_config_Stream1_uri oslc_config:component ?component. ?oslc_config_Stream1_uri rdf:type oslc_config:Stream. OPTIONAL {?oslc_config_Stream1_ver dcterms:isVersionOf ?oslc_config_Stream1_uri; rdf:type oslc_config:VersionResource.} BIND( IF (bound(?oslc_config_Stream1_ver), concat(str(?oslc_config_Stream1_uri), "?oslc_config.context="), ?oslc_config_Stream1_uri) as ?oslc_config_Stream1) } GROUP BY ?component } } ORDER BY ?projectTitle ?componentTitle </verbatim> ---++ List baseline names with their UUIDs <verbatim> # Configuration PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX oslc: <http://open-services.net/ns/core#> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX oslc_config: <http://open-services.net/ns/config#> PREFIX oslc_core: <http://open-services.net/ns/core#> PREFIX prov: <http://www.w3.org/ns/prov#> PREFIX jazz_process: <http://jazz.net/ns/process#> PREFIX jazz_process2: <http://jazz.net/xmlns/prod/jazz/process/1.0/> SELECT * WHERE { # Filter resource # Fetch properties possibly used in views OPTIONAL { ?resource dcterms:creator/foaf:mbox ?creator_mbox } OPTIONAL { ?resource rdf:type ?type } OPTIONAL { ?resource dcterms:title ?simpleTitle } OPTIONAL { ?resource dcterms:description ?description } OPTIONAL { ?resource dcterms:modified ?modified } OPTIONAL { ?resource dcterms:identifier ?identifier } OPTIONAL { ?resource oslc:shortId ?shortId } BIND ( if (bound(?shortId), ?shortId, ?identifier) as ?id2 ) BIND ( if (isNumeric(?id2), ?id2, xsd:integer(?id2)) as ?id ) OPTIONAL { ?resource oslc_config:mutable ?mutable } FILTER regex(str(?type),"#Baseline","i" ) BIND ( IF (bound(?simpleTitle), str(?simpleTitle), str(?resource)) as ?title) BIND ( IF (bound(?shortId), str(?shortId), "") as ?shortIdStr) BIND ( IF (bound(?mutable) && ?mutable, concat("Stream ", ?shortIdStr), concat("Baseline ", ?shortIdStr)) as ?shortTitle ) # order by (global/local), (stream/baseline) and then title BIND ( IF (bound(?mutable) && ?mutable, concat("_1_", ?title), concat("_2_", ?title)) as ?type_order ) BIND ( IF (bound(?shortId), concat("1_", ?type_order), concat("2_", ?type_order)) as ?order ) } </verbatim> <sticky></div></sticky>
E
dit
|
A
ttach
|
P
rintable
|
V
iew topic
|
Backlinks:
We
b
,
A
l
l Webs
|
H
istory
: r2
<
r1
|
M
ore topic actions
Deployment
Deployment web
Planning and design
Installing and upgrading
Migrating and evolving
Integrating
Administering
Monitoring
Troubleshooting
Community information and contribution guidelines
Create new topic
Topic list
Search
Advanced search
Notify
RSS
Atom
Changes
Statistics
Web preferences
NOTE: Please use the Sandbox web for testing
Status icon key:
To do
Under construction
New
Updated
Constant change
None - stable page
Smaller versions of status icons for inline text:
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our
Terms of Use.
Please read the following
disclaimer
.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more
here
.