How can I tell if data is in AGOL or Enterprise Portal?

[JR_CHN]

Very new to having to manage some Enterprise system/data, and we are eating up a lot of ESRI credits, so I need to identify what items are living in our Enterprise Portal vs ESRI Online to find the datasets that need to migrate to the Enterprise Portal so they don't take up ESRI Credits.

Is there a place in ArcGIS Pro's catalog window, or the AGOL dashboard item details that will tell me where the data is being hosted?

[jcarlson · Accepted solution]

On the item page in your Portal / AGOL, you can see the URL for any feature layers. In Pro, you can also see the URL in the item's properties window.

If this spot, in the lower-right of the Item page, shows an arcgis.com URL, it's AGOL.

[berniejconnors]

Since you are only concerned with the items that are consuming credits you can use an ArcGIS Notebook to get a list of all the items in your organization.  This sample Notebook should get you started.  Remember it is the database storage that is the most expensive so look for large Feature layers or Feature services hosted in AGOL.

Building this dashboard will help you monitor for new items added to your AGOL organization.  I used this blog to replicate the dashboard for my AGOL organization.  Here is a sample image from our dashboard showing recent increases in feature service storage:

Good luck,

Bernie.

[BenClark]

Yeah, looking at the source URLs in Pro can be an easy way to determine which service is hosted where. Attached are screenshots of an old service I have hosted in ArcGIS Online vs. a newer one hosted in our Enterprise deployment. Note the differences in URLs. 

Edit: Of course you don't have to be in the Source tab in the ArcGIS Pro table of contents to see this information, but if I'm trying to figure out where something is coming from it can sometimes provide useful information. Irrelevant here though.

[HenryLindemann · Accepted solution]

Hi @JR_CHN, if the service type is a Hosted Feature in AGOL, it's is hosted online, if it does not have the hosted tag it is referenced and either coming out of a 3rd party system or your Enterprise.

Then you need to go to Organization -> Status -> Reports -> Create report -> Single report

select Item

create and download the report.

you open the csv in excel then select column A go to Data Tab.

Select Text to Column

Delimitated then comma.

The Columns you are interested in is K Feature Storage and P is hosted.

Feature Storage is the expensive storage whereas File storage is very cheap.

If is Hosted is true you are being billed for the service.

Regards

Henry