Original Message:
Sent: 07-01-2021 11:45 AM
From: Igor Perevozchikov
Subject: Question about this CEM Report
There is no default reports which will show how much data is transferred via CEM only because client can start downloading via UNC, P2P or Http(s) in intranet mode and then switch to CEM mode and continue downloading remaining data of package via Https so it is not possible to determine that client exactly downloaded this data when it was only in CEM mode.
For example, there is "Packages Distribution by Download Type" report which shows packages, their size, amount of downloads and how it was downloaded by clients.
By mouse double click on package name, you can drill-down report to see which client computers downloaded it and how (UNC, P2P or Http(s))
Download history of packages by client computers also stored in Evt_AeX_SWD_Package SQL table.
I've created today custom report where you can filter out report data output to see only for last %N% days information and also can choose required Org group then report data will be shown only for them. It's just for summary to see how fast, how often computers are downloading packages (it doesn't show exact cases when package was downloaded when client in CEM)
Download attached "Information about downloaded packages by managed client computers.xml" > open SMP Console > Reports > All Reports > mouse right click on root "Reports" folder > Import .xml
Thanks,
IP.
------------------------------
Software QA Engineer
Broadcom Inc.
Original Message:
Sent: 06-30-2021 11:31 AM
From: ENRIQUE DEGUZMAN
Subject: Question about this CEM Report
Thank you. Is there a report that would show amount of data the internet based clients are receiving, a daily aggregate? we want to know how much CEM is being utilized.
------------------------------
mklesa
Original Message:
Sent: 06-30-2021 06:16 AM
From: Igor Perevozchikov
Subject: Question about this CEM Report
Hello HXG!
Part of query of this report shows that it calculates sent & received bytes
SELECT tmp.id, tmp.EndDate AS [Date],
MAX(evt.[Sent Bytes] + evt.[Received Bytes]) AS [Max Transferred Data],
MIN(evt.[Sent Bytes] + evt.[Received Bytes]) AS [Min Transferred Data]
FROM [dbo].[Evt_AeX_AC_CEM_Gateway] evt
JOIN #tmp_Period tmp ON evt._eventTime BETWEEN tmp.StartDate AND tmp.EndDate
WHERE @Gateway = '%'
OR @Gateway = evt.Gateway
GROUP BY tmp.id, tmp.EndDate
ORDER BY tmp.id
Since only internet based clients are working (downloading all data, such as policies, packages from Package servers and sending events to Notification Server which isn't in internet and is in intranet) through CEM Gateway this report shows inbound/outbound data.
Thanks,
IP.
------------------------------
Software QA Engineer
Broadcom Inc.
Original Message:
Sent: 06-29-2021 05:13 PM
From: ENRIQUE DEGUZMAN
Subject: Question about this CEM Report
I have a question trying to understand the report called "Transferred Data trend by Gateway" found in
Reports > Notification Server Management > Cloud-enabled Management > Gateway .
What is Min and Max transferred data? is it outbound and inbound data?
attached is the screenshot of the graph:
------------------------------
mklesa
------------------------------