This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.
The first query which prompts for the date: PARAMETERS [Enter the Start Date:] DateTime, [Enter the End Date:] DateTime; SELECT Format([Date],"mmmm"", ""yyyy") AS CalculatedMonth, JobsPerHour.Area, [Jobs]/[Worked] AS JPH, Format([Date],"yyyymm") AS SortedMonth FROM JobsPerHour WHERE (((JobsPerHour.Date)>=[Enter the Start Date:] And (JobsPerHour.Date)<=[Enter the End Date:])) ORDER BY Format([Date],"yyyymm"); The crosstab query, which calls on this first query: TRANSFORM Avg(Query1.JPH) AS AvgOfJPH SELECT Query1.Area FROM Query1 GROUP BY Query1.Area ORDER BY Query1.CalculatedMonth ASC PIVOT Query1.CalculatedMonth; and the report - see attachment
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.