cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alena1...@apache.org
Subject git commit: updated refs/heads/4.2 to f9faf1a
Date Wed, 31 Jul 2013 22:28:34 GMT
Updated Branches:
  refs/heads/4.2 4f111d284 -> f9faf1aea


CLOUDSTACK-3982: listAccounts - count only UserVms when calculate total number of Running
vms per account


Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/f9faf1ae
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/f9faf1ae
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/f9faf1ae

Branch: refs/heads/4.2
Commit: f9faf1aea2f3dbb47c60eaefcd999290dff837e7
Parents: 4f111d2
Author: Alena Prokharchyk <alena.prokharchyk@citrix.com>
Authored: Wed Jul 31 15:18:22 2013 -0700
Committer: Alena Prokharchyk <alena.prokharchyk@citrix.com>
Committed: Wed Jul 31 15:18:59 2013 -0700

----------------------------------------------------------------------
 setup/db/db/schema-410to420.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/f9faf1ae/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index 1650e2f..3f25c3b 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -2211,3 +2211,14 @@ CREATE TABLE `cloud_usage`.`usage_vmsnapshot` (
 ALTER TABLE volumes ADD COLUMN vm_snapshot_chain_size bigint(20) unsigned;
 
 INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server',
'kvm.ssh.to.agent', 'true', 'Specify whether or not the management server is allowed to SSH
into KVM Agents');
+
+#update the account_vmstats_view - count only user vms
+DROP VIEW IF EXISTS `cloud`.`account_vmstats_view`;
+CREATE VIEW `cloud`.`account_vmstats_view` AS
+    SELECT 
+        account_id, state, count(*) as vmcount
+    from
+        `cloud`.`vm_instance`
+    where
+        vm_type = 'User'
+    group by account_id , state;
\ No newline at end of file


Mime
View raw message