.... i know there is a report available but i think one of the user tried to modified it and now its shwoing same subnet over and over.
can some one send me the format of original report so i can change it back to default.
bhavikdalsania: give this a shot first - IPAM Subnet scanning.
If you need additional help, please return and we will get you on the right path.
Thanks for reply but this what not i am looking for. you know when we creat report when need to select all those fields in order to get the particular data.
If you can give me snapshot of those field from report writer for IPAM all subnets.
Is this what you are looking for?
Here's the back-end SQL:
SELECT IPAM_GroupReportView.FriendlyName AS Display_Name, IPAM_GroupReportView.Address AS Network_Address, IPAM_GroupReportView.AddressN AS Address_Sort_Key, IPAM_GroupReportView.CIDR AS CIDR, IPAM_GroupReportView.LastDiscovery AS Last_Discovery, IPAM_GroupReportView.PercentUsed AS IP____Usage, IPAM_GroupReportView.UsedCount AS IP__Used, IPAM_GroupReportView.TransientCount AS IP__Transient, IPAM_GroupReportView.AvailableCount AS IP__Available, IPAM_GroupReportView.ReservedCount AS IP__Reserved, CASE AllocSize WHEN 0 THEN 0 ELSE ISNULL( CAST( TotalCount as decimal ) / CAST( AllocSize as decimal ) * 100.0, 0.0 ) END AS IP____AllocatedFROM IPAM_GroupReportViewWHERE ( (IPAM_GroupReportView.GroupType = 'Subnet'))ORDER BY 3 ASC, 4 ASC
Thanks for reply that's what i was looking let me try this.
