-- In v2.0.
-- Get the latest inventory_index_id.
SET @inventory_index_id = (SELECT id FROM inventory_index ORDER BY id DESC LIMIT 1);
-- Number of projects inventoried.
SELECT Count(*) number_of_projects
FROM gcp_inventory
WHERE gcp_inventory.index = @inventory_index_id
AND gcp_inventory.type = 'project'
AND gcp_inventory.type_class = 'resource';
-- Number of service accounts inventoried.
SELECT Count(*) number_of_service_accounts
FROM gcp_inventory
WHERE gcp_inventory.index = @inventory_index_id
AND gcp_inventory.type = 'serviceaccount'
AND gcp_inventory.type_class = 'resource';
Cordialement / Best Regards
CASTEX Antoine
Cloud Developer
Technology & Operations - Digital Factory
Group Information Systems & Technology (IS&T)
VEOLIA 30 rue Madeleine Vionnet / 93300 Aubervilliers / France
Bureau : 0 - Ouest - 137F
Direct: +33 1 85 57 70 91
Mobile: +33 6 10 93 63 49
--The team is looking for testers of Forseti Security 2.0 Release Candidate 1.We want your input, either as a developer or user, on the improvements we’ve made in 2.0. If you’re interested, please join to the beta-testers@forsetisecurty.org distribution list.In a few days we will update members of that distribution list with the steps to download and test.We are asking people who join our beta testing list to do the following:
- Install and test Forseti Security 2.0
- Provide feedback to us
- Open issues and offer debugging information when requested
We’re looking forward to your help to make Forseti better!Thanks in advance,-The team at Google working on Forseti
You received this message because you are subscribed to the Google Groups "Forseti Security Announce" group.
To unsubscribe from this group and stop receiving emails from it, send an email to announce+unsubscribe@forsetisecurity.org.
We want your input, either as a developer or user, on the improvements we’ve made in 2.0. If you’re interested, please join to the beta-t...@forsetisecurty.org distribution list.
In a few days we will update members of that distribution list with the steps to download and test.We are asking people who join our beta testing list to do the following:
- Install and test Forseti Security 2.0
- Provide feedback to us
- Open issues and offer debugging information when requested
We’re looking forward to your help to make Forseti better!Thanks in advance,-The team at Google working on Forseti
--
You received this message because you are subscribed to the Google Groups "Forseti Security Announce" group.
To unsubscribe from this group and stop receiving emails from it, send an email to announce+unsubscribe@forsetisecurity.org.
--------------------------------------------------------------------------------------------This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited.Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers+unsubscribe@forsetisecurity.org.
To post to this group, send email to beta-testers@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqRHQCX6MgVwa5HBjO6hD_cVOCajMkB9UEpyy1SZq-dQVMw%40mail.gmail.com.
Cordialement / Best Regards
CASTEX Antoine
Cloud Developer
Technology & Operations - Digital Factory
Group Information Systems & Technology (IS&T)
VEOLIA 30 rue Madeleine Vionnet / 93300 Aubervilliers / France
Bureau : 0 - Ouest - 137F
Direct: +33 1 85 57 70 91
Mobile: +33 6 10 93 63 49
Yeah, I brought this up in an earlier thread and provided the replacement examples for the doc, but nobody has had a chance to update it yet./l
👍
Cordialement / Best Regards
CASTEX Antoine
Cloud Developer
Technology & Operations - Digital Factory
Group Information Systems & Technology (IS&T)
VEOLIA 30 rue Madeleine Vionnet / 93300 Aubervilliers / France
Bureau : 0 - Ouest - 137F
Direct: +33 1 85 57 70 91
Mobile: +33 6 10 93 63 49
On Wed, Apr 25, 2018 at 4:17 PM, Lukas Karlsson <karl...@broadinstitute.org> wrote:
Yeah, I brought this up in an earlier thread and provided the replacement examples for the doc, but nobody has had a chance to update it yet./l
To unsubscribe from this group and stop receiving emails from it, send an email to announce+u...@forsetisecurity.org.
--------------------------------------------------------------------------------------------This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited.Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqRHQCX6MgVwa5HBjO6hD_cVOCajMkB9UEpyy1SZq-dQVMw%40mail.gmail.com.
--Lukas Karlsson, Cloud Architect / Developer Advocate
Broad Institute of MIT and Harvard
75 Ames Street, 11129, Cambridge, Massachusetts 02142
karl...@broadinstitute.org, +1.6177147142
--------------------------------------------------------------------------------------------This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited.Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqRFPuxhUOex8ib-F8CwR27MVCits8-EnF5AHDuC22oDrCA%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAD2SjSoR78KTJ9gvt7LEDp4nPSce_S%2BabDqpaHQF_RffxwLckw%40mail.gmail.com.