PubChem service doesn’t support looking up compounds given an assay ID?

Mathematica’s PubChem Service Connection has many requests that return the properties of a compound (or substance). It also provides requests that return all the assays for which a given compound (or substance) has been tested.

But the PubChem Service Connection does not appear to include requests that return all the compound IDs (CIDs) associated with a given assay ID (AID). This type of functionality is supported by the PubChem PUG-REST, e.g., :

https://pubchem.ncbi.nlm.nih.gov/rest/pug/assay/aid/1207599/cids/txt

Looks up all compounds (CIDs) that have been measured with assay AID1207599.

The “CompoundAID” request in Mathematica returns a list of AssayIDs given a CompoundID (or other CID-equivalent specifier) as input. Similarly, “CompoundAssaySummary” returns a summary given a CompoundID (or equivalent) specifier. But returning the AIDs for a specified CID is not the same as returning the CIDs for a given AID. Is there an undocumented feature for this?

No: It is not possible to iterate over all CompoundIDs; PubChem contains >96 million compounds.

Yes: I already know I can do it “manually” by

URLExecute[  "https://pubchem.ncbi.nlm.nih.gov/rest/pug/assay/aid/1207599/cids/txt",  {}, "CSV"] 

Rather: This is a question about the limits and current state of the PubChem Service Connection implementation in Mathematica 12.

Investigate potential breach in Azure App Service

I asked on Server-Fault, but have not received any response so thought I would try here.

We suspect we have had a data breach, but we are not sure how to investigate it to determine the source of the breach or what data was sent.

We have an app service that has been running for a while with steady usage. We noticed that over the last couple of nights there have been large spikes in data out. Our website has an authenticated user area and we are concerned that there may have been a breach or something unauthorized happening on the site.

The site has consistently always had below 10MB/15mins Data Out. But the sudden spike was over 180MB then instantly back down again. The second night the spike was 600MB. In the same 15 minute metric window the Average CPU time spiked to over one hour. Response time, number of requests and 4xx/5xx errors all remained steady.

Azure metrics graph

Is there a way using Azure (Metrics or Security Center) to determine what caused the massive spike in Data Out? What data was sent, who it was sent to etc? Is there anything we can enable within Azure to allow us to view this data if it was to happens again tonight? (e.g. Azure Sentinel)

Looking at other metrics, there was no obvious spike in 4XX or 5XX errors or number of requests, so we do not suspect a brute force or DoS attack.

Security of service requests on a public Wifi

I’m currently rebuilding my network infrastructure and am planning to make my NAS available trough an OpenVPN server running on my router for “outside” use (no port forwarding: NAS in private LAN, available trough the VPN).

Now I was wondering about a certain scenario: let’s say, I have mapped some of the NAS’s drives as network drives via SMB/CIFS in Windows on my laptop (using the local IP address of the NAS in the LAN) or have a proprietary software of the NAS’s manufacturer trying to connect to a certain service on a dedicated port.

If I were to take this notebook to an unsecured, public wifi- would this expose the local LAN IP’s and/or ports in the CIFS request or the connection request coming from the proprietary software until I’m connected to my VPN (i.e. in the very moment, I’m connecting to the wifi until the VPN tunnel is up)? Does this depend on the way such a request is implemented in the software?

Is there something like DynDNS for a DNS service?

I run a small DNS server (pihole) at home behind a firewall, with some custom filtering. I have an IPv4 address (not fixed) with my ISP and could use DynDNS for HTTP traffic to my home.

Now I would like to use my home-based DNS server on my mobile phone when traveling. How could I possibly do that?

Since the IP is not fixed, I will not be able to provide a fixed IP for DNS resolution. I would need something that gets the IP first. Like DynDNS for DNS.

Does such a dynamic IP resolution for DNS exists?

Note: I would like to not use a VPN connection since I do not need to re-route the subsequent traffic to my home, I just want to use my DNS server.

Is Customer Service Agent and the Customer two different personas or different roles?

Are ‘Personas’ and ‘Roles’ different in every scenario?

Although i did my reading about roles and personas, im a bit confused about this topic with the context i’m working on.

Scenario – One day Bruce(Customer) finds out his water heater is broken and calls XYZ company to get it fixed. John(Customer service agent) receives the call and assigns Bob(Technician) for to install a water heater.

John, Bruce and Bob are these 3 personas? or are they considered as 3 different user roles who interact with XYZ service?

Is it normal that the service WMI Performance Adapter always starts when launching Chrome browser? Whats the reason

Is it normal that the service WMI Performance Adapter (WmiApSrv.exe) always starts when launching Chrome browser? Whats the reason?

I have heared this service can be maliciously used to “communicate” through the internet via open ports?

When I forcefull end this process in the taskmanager, Chrome keeps running perfectly, without issues.

Could it be that this WMI process is needed because one of Chrome’s features called “Conceal local IP addresses with mDNS hostnames”?

Thanks!